Query to calculate totals from main table

[laina222]

I need to create a query that takes the records from another query and totals each instance of each field. For example, the query I have specifies records from four fields in a date range, Source, Brand, Resolution Code (Satisfied or Not Satisfied or Pending) and the Complaint that Source had. I want to take the records from that query and calculate the total number of each specific type of Source, each brand, each resolution code and each complaint. There are five different sources to choose from, five brands, three Resolution Codes and 18 Complaint Descruiptions. I want to total, for example, how many records from the specified date range had "Satisfied" for the Resolution Code. I already know how to do SQL to find the totals (SELECT COUNT (ResolutionCode) FROM tblName WHERE ResolutionCode = "Satisfied&quot but I don't know how to set it up in the design view for the query. Any help?

 

[THoey]

Laina, did you know that you can switch from from the standard design view (I think I have heard it called QBE) to a SQL view? First menu item on the left of the tool bar. Cut and paste your query there and then switch back to design view to see how Access converted it.

If I misunderstood your question, I apologize... Terry M. Hoey

 

[laina222]

I know that already. I guess my real question is how can I create a report based on about 20 different queries? Is it possible, because everytime I try to start the report wizard and do it I get an error message.