[Year 12 IT Apps] Access Help Please!!!

[Keith Richardson]

Hi all you Access Experts.
Three of us have a problem - how do we get Access to tell us which age
group an individual belongs to (Junior 10-12, Intermediate 13-14, Senior
14-18) starting with date of birth (an entered field in the members
table). We worked out how to create a query that would get current age
based on date-now and dob, then selection based on a particular age
range for criteria, but that simply gives me a list of member names who
fall into
that age group at any time. What I want to do is flow that information
into something that will flow into a report, without having to manually
look through the lists of names of members in a particular age group.
Hope that isn't too complicated!
Regards, Keith (for Keith, Henry & Diane)
Keith Richardson