kentwoodjean
Technical User
From a query, I have created a report with the following fields:
Complaint Date (Where)
Response Date (Where)
Category (Group)
ID Description (Group)
Comments ( I don't know what to put here)
Complaint (yes/no check box on form) - (Count)
I show YES fof the criteria for complaint so it will give me only those boxes checked as a complaint. I want to total the number of checked boxes that are a yes for each ID Description under a category but I can't figure out how to do it.
Also, what do I do with my comments related to each complaint since that field does not fit into any of the "Totals" functions.
Complaint Date (Where)
Response Date (Where)
Category (Group)
ID Description (Group)
Comments ( I don't know what to put here)
Complaint (yes/no check box on form) - (Count)
I show YES fof the criteria for complaint so it will give me only those boxes checked as a complaint. I want to total the number of checked boxes that are a yes for each ID Description under a category but I can't figure out how to do it.
Also, what do I do with my comments related to each complaint since that field does not fit into any of the "Totals" functions.