Help calculating AGE!!

E

Ess

I found a following formula, for age calculation, in this forum. I like it
because it give years and months. See below:

Age: (DateDiff("m",[DOB],Date())+(Day([DOB])>Day(Date())))\12 & " yrs
" & (DateDiff("m",[DOB],Date())+(Day([DOB])>Day(Date()))) Mod 12 & " mos"

When I used this formula it yielded a weird age. For a person with a
birthdate of 6/1/2005, the result is 15 yrs 1 mos.

What am I doing wrong?
 
E

Ess

I'm not really sure what happened but the query works like a charm now.

Next issue is, now that I have the age, I have to create age categories
based on age (e.g. age 0 - 2 mos; 3 - 11 mos; 1 - 5 years; 6 - 13 yrs; etc.)
then do a count of each age within that particular age category.

Should I create this within the same query or create a table identifying
which category an age should fall under then do a count?

What's the most effecient way of obtaining this information?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Current Date in Query 12
Age calculation in Query 6
Calcualating age by month day and year 3
Calculating Age from Birthdate field in Query 4
how to filter data 2
Date difference to show in years and months 2
basage modular 4
Calculating age with If statement 2

Top