Calculating Age

[René]

OK, I admit this is a refresher questions, can't find my notes in my piles.

On my employee form, I have two calculated fields one is for their age and one is for employment length. This were originally set up as event procedures on "On Update"

How or can I set it up so that everytime that I open the form these numbers are updated.

I print out the hard copy in report format so I realize that those numbers are always correct. But they are also only in years and I would like to be able to have them in years and months

Thanks in advance, you guys always bail me out

 

[Douglas J. Steele]

Neither of those values should be stored in your table. Instead, you should
create a query with two computed fields, and use that query wherever you'd
otherwise use the table. That will guarantee that your values will always be
correct.

One approach to show more than just years is the Diff2Dates function I have
at http://members.rogers.com/douglas.j.steele/Diff2Dates.html

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

OK, I admit this is a refresher questions, can't find my notes in my piles.

On my employee form, I have two calculated fields one is for their age and

one is for employment length. This were originally set up as event
procedures on "On Update"

How or can I set it up so that everytime that I open the form these numbers are updated.

I print out the hard copy in report format so I realize that those numbers

are always correct. But they are also only in years and I would like to be
able to have them in years and months