Running a query to calculate age from the date of birth

[chedd via AccessMonster.com]

Hi

I am trying to run a query to be able to calculate their ages from a table
refering to their date of birth.

Please can help with a formula i need to be able to accomplish this.

Thanks for help in advance

chedd

 

[Allen Browne]

I am trying to run a query to be able to calculate their ages from
a table refering to their date of birth.

Here you go:
http://allenbrowne.com/func-08.html

The article explains why some common attempts don't work and gives a
solution that works regardless of your regional date format, and with the
option to specify the date when the age should be calculated.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"