Maybe something like this can help:
select DateDiff("yyyy", BirthDate, Now) as Age
from Table
where DateDiff("yyyy", BirthDate, Now)>=1
and DateDiff("yyyy", BirthDate, Now)<99
How do you filter the records?
Is this for a report? or a form?
Regards,
Carlos.