Create a new field in the query called agegroup, hoping that u already have age converted from DOB, then this must work 100% well. just copy and paste.
agegrp: Format((IIf([age] Between 0 And 0,"less 1 year",IIf([age] Between 1 And 4,"1-4 years",IIf([age] Between 5 And 14,"5-14 years",IIf([age]...