AGE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ransom - 20 Jun 2007 14:23 GMT

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

Reply to this Message

Douglas J. Steele - 20 Jun 2007 14:47 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> hi everyone,...a two parter....
>
[quoted text clipped - 10 lines]
> thanks
> Ransom

Reply to this Message

Ransom - 20 Jun 2007 15:08 GMT

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

> For question 1, Access doesn't have anything like that built in, but take a
> look at http://www.accessmvp.com/djsteele/Diff2Dates.html
[quoted text clipped - 18 lines]
> > thanks
> > Ransom

Reply to this Message