Sum of a categorized filed

[Costa]

Hello All ..


I have a field named (Inspection type) contains 3 types of inspection

I want to make a report that give me the sum of each type in the header of the report for each inspector.

For example :
Inspection Type: Workshops
Inspection Type: Factory
Inspection Type: outside Works

The inspector visited the the workshops .. let's say 5 times in a month
and visited 20 factories

How can I get a report for the inspector that contain the total of factories and total of workshops he visited ???

in Access 2007 I only know how to get the sum of the filed but not the sum of a specific type !

Hope you understand what I want to do here and help me with it

Thanks