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

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

hth,

Michael

thanks, I will try it