Barb Crosby
Last Activity: Jan 13 '11, 06:31 PM
Joined: Jan 10 '11
Location:
-
I'm sorry, but I'm not sure what you mean? integer division and mod division. Could you give me an example on how I would write the query?
The result of my query as I have it written gives me .67 years as opposed to 7 months. Is there a way to do this?Leave a comment:
-
LengthofEmploym ent: IIf(IsNull([TerminationDate]),DateDiff("m",[HireDate],Now())/12,DateDiff("m" ,[HireDate],[TerminationDate])/12)Leave a comment:
-
Barb Crosby started a topic How do I express a datediff in years & months? for example: 2 yrs 3 monthsin AccessHow do I express a datediff in years & months? for example: 2 yrs 3 months
I am using a query:
LengthofEmploym ent2: IIf(IsNull([TerminationDate]),DateDiff("m",[HireDate],Now())/12,DateDiff("m" ,[HireDate],[TerminationDate])/12)Last edited by Barb Crosby; Jan 11 '11, 03:11 PM.
No activity results to display
Leave a comment: