Find ages 10-20 during 2002

[MaggieLeatherman]

Hi

I need to query to find how many members from Members table were between 10 and 20 years old in 2002.

Not sure how to begin. Thanks, Maggie

 

[sfreeman]

If you want to see those records:

SELECT
Table1.*
FROM
Table1
WHERE
(((Table1.dob)
Between #1/1/1982# And #12/31/1992#));

If you want to count those records:

SELECT
Count(Table1.ID) AS CountOfID
FROM
Table1
WHERE
(((Table1.dob) Between #1/1/1982# And #12/31/1992#));



HTH

 

[MaggieLeatherman]

Thanks for the info.
I need to narrow down the year to 2002.
How would that work?

 

[sfreeman]

I thought I did that. This record set represents all of those who, in 2002, where between the ages of 10 and 20.