Simple Query

[pickslides]

Been trying to crack this one for a while.

DB attached, trying to write a query that outputs.

Group By State, Count of Type A, Count of Type B, Total Count of Type, Count of comments.

Thanks MQ..

 

[plog]

Here's what you would need for 'CountOfA':

CountOfA: Iif([Complaint_Type]="A", 1,0)

Make that an aggregate query (Click the Sigma/Summation symbol) then change the 'Group By' to Sum. What that will do is count the record as 1 if it is A and 0 if not. Then it sums up all those 1's and 0's.

Make similar fields for your other types.