Derived Values

[Expe]

I need help using a function or query to calculate length of service based on employee hire date (table column) and current/today's date. I will appreciate your assistance.
Thank you in advance!
Expe

 

[plog]

You will use the DateDiff function: http://www.techonthenet.com/access/functions/date/datediff.php

 

[Ranman256]

in the query,:
dateDiff("d",[HireDate],Date()) as DaysOnJob

 

[Expe]

Thanks, Ranman256 - The function dateDiff("d",[HireDate],Date()) works except that I get an error message when I try to use it in a Calculated Field with the message that it cannot be used in a calculated field. Any advice?
Expe

 

[jdraw]

Tell us about your table(s) and the reason for the calculated field.

 

[Expe]

Thanks.
I have an EMPLOYEE table with DateOfHire and LenghofService (LOS) among the fields. The LOS value should be derived based on the hired date and the current/sysdate.
Once again, thanks for your help!
Expe

 

[jdraw]

You do not store values that you can calculate. Use a query to get the desire value.

LOS (in days) can always be determined from DateDiff("d", HireDate, Date)