Ages Query

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?

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




"dukes1234" wrote in message
lkaboutsoftware.com...
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?