Summary Query

[Jose]

Hello,
I have a little problem and I dont know what approach to adopt. Basically I have a table with the following fields:
Dept, Error, Fund ,Customer, Number units, Cheque Value, compensation Type and Status ( Please the excel file that I have attached )

I would like to create a query that groups by Dept, Error and Fund and gives me:

Total number of compensations
Total number of units compensations
Total number of cheque compensation
Total number of unit compensations completed
Total number of cheque compensations completed

I have included an example in a excel file attached to this post.

I appreciate your help.

J

 

[John Big Booty]

Have a look at the Group BY or Totals query. Put you query into design view and click the Sigma (Σ) button in the tool bar. You will notice that a new row appears in the design view (Total:), this will allow you to do various functions in your query such as Group BY, Sum, Count etc.

 

[Jose]

thanks John. I knew about the totals query but I missed to use an iif function