Grouping Data

[StephenD]

Does anybody know what is the best way to group data in a query??

I have a big chuck of data with a date of birth field-I want to add an age group field based on the date of birth e.g 0-17 years, 18-24 years and so on.
Can you do it using IIf or is there another way???

Thanks!

 

[StephenD]

That's great, thanks Pat I will go and try this out!