Access

[Guest]

Can access calculate a date of birth in a table? If so how?

 

[Guest]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbadev/html/calculatingage.asp

I found some information on that at the url above.

 

[John Vinson]

Can access calculate a date of birth in a table? If so how?

Only if you have information in the table (such as the exact age at a
given date, or the longitude of the Sun, Moon and Jupiter at the time
of birth), say.

Perhaps you meant to ask, can you calculate the current age *given*
the date of birth? if so:

Age: DateDiff("yyyy", [DOB], Date()) - IIF(Format([DOB], "mmdd") >
Format(Date(), "mmdd"), 1, 0)

John W. Vinson[MVP]