Counting different students age in same queri from same table

[crododo]

Hi,

I have one table that has fields:
[ID]
[STUDENT_NAME]
[BIRTH_DATE]
[GENDER]
and I neet to get in qry where students will be counted by age and gender

For example:
younger then 15
tolal: 20
male: 5
female: 15

15-18 years
tolal: 34
male: 12
female: 22

Can this be done in single queri or should I do it in some other way?

Thanks for help

 

[namliam]

Can definately be done in one query and quite easily ..
There are a many different posts on calculating age using for example DateDiff function.
Then use IIf or some different function to "bracket" the ages and/or split the genders.

 

[crododo]

Hi,

I am trying to find it for past few hours, but no luck so far ;(

Any idea where I can find it?

Thx