I have to do a report of cases I've worked on during the year
I can tally gender (m,f) =Sum(IIf([sex]="f",1,0)) then I do it again for M
Is there a way to group "age" such as 11-13.14-17 etc. I did it in a count but now I want to summarize in the report footer

Sadie,

I think you can use the Partition function.

Use the Search Facility here and look for "Partition". Also Access Help
has an example.

Wayne

I would create a report that does the summary and place it in the main report's footer. You can use the GroupInterval property to create groups as long as the interval is constant. If you want to do the grouping in a query, take a look at the Partition function.

thanks, I'll try it