D
Douglas J. Steele
Take a look at the code in http://www.mvps.org/access/datetime/date0001.htm
at "The Access Web"
How you use that code depends on what you're trying to do. For example, if
you want to create a query that returns the person's name and age, you can
simply add
Age: DateDiff("yyyy", [Bdate], Now())+ Int( Format(now(), "mmdd") <
Format( [Bdate], "mmdd") )
into an empty cell on your query grid.
at "The Access Web"
How you use that code depends on what you're trying to do. For example, if
you want to create a query that returns the person's name and age, you can
simply add
Age: DateDiff("yyyy", [Bdate], Now())+ Int( Format(now(), "mmdd") <
Format( [Bdate], "mmdd") )
into an empty cell on your query grid.