report problem

[sadie]

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

 

[WayneRyan]

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

 

[sadie]

thanks, I'll try it