grouping in reports

[sadie]

I need to do an annual report for all the cases I reviewed all year
I have a lot of fields such as age,gender,IQ,ethnicity, referral source, county etc...
I need to count how many in each field
What is the best way to to achieve this
Thanks

 

[Ukraine82]

You can make a crosstab query that will give the count for each fields.

hth,

Michael

 

[sadie]

thanks, I will try it