calculating age by date of birth

[Jaime P.]

Anyone know if there's an easy (non-SQL) way to calulate,
in a query, a person's age if his DOB (in date format)is
contained within the query?

 

[Douglas J. Steele]

Check http://www.mvps.org/access/datetime/date0001.htm at "The Access Web"

 

[Jaime P.]

that worked beautifully... thank you so much!

-----Original Message-----
Check http://www.mvps.org/access/datetime/date0001.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP






.