Ages Query

D

dukes1234

I'm trying to find the number of infant participants aged 0 to 11 months
and 12 to 23 months within my database in 2004. For 0 to 11 I just put in
"Between 1/1/2004 and 12/31/2004" in the birthdate criteria to account for
the children born in that year. How would I run a query for the kids in the
12 to 23 months range?
 
R

Rick B

You should rethink this. What happens next month? What about tomorrow?
You need to make it dynamic. Look at datediff and come up with a formula
that will subtract the current date from the birthdate and return the number
of months. Then, in your criteria put something like, "between 0 and 11 OR
Between 12 and 23"

Rick B
 
Top