Calculating Age

[Koyangie]

I'm working on a Church database which will generate a Members Directory which contains Children's age. I have a field for date of birth and age and want to automatically populate the child age so we don't have to manually enter a new age with each new directory. I cannot seem to get my query to return the value for age either using DateDiff() or Today-DoB. I know I need to count the difference in total months and divide by 12 to arrive at an age. Is there a simple Query that will calculate the age for me. I have "The Missing Manual" but have been unable to crack this function; which seems like it should be fairly simple to do. Can someone guide me in creating this calculation. Thanks
Koyangie

[pbaldy]

A brief search yielded hundreds of hits, including this one:

http://office.microsoft.com/en-us/ac...001055071.aspx

[orange]

see http://allenbrowne.com/func-08.html

I see Paul responded while I was typing. Anyway, this info from Allen Browne is worth reading.