AGE

[Guest]

hi everyone,...a two parter....

I am trying to calculate the age and months of service. I used the
calculate age function, however I wanted to know if I could get age along
with the months as well....for example....6 years 8 months? Does access do
that


Also if I put a number say 20 in one field.....how can i get it to
subtract...For example....I am starting with 10 vacancies and on monday I
input 3...Id like to, when i open it again be able to see the number 7.


thanks
Ransom

 

[Douglas J. Steele]

For question 1, Access doesn't have anything like that built in, but take a
look at http://www.accessmvp.com/djsteele/Diff2Dates.html

For question 2, typically you don't really want to do that. (you usually do
not want to store calculated values). What you do instead is have a table of
transactions against that total, and calculate the current total whenever
you need it through the use of a query.

 

[Guest]

great thanks!!!

i figured that for the second one...and i had done that, but i just wanted
to make sure...appreciate your help!
Rw