Summing yes/no fields

[imwalrus38]

How do I report on the number of times yes or no was selected on a given record. I have a data base where I'm collecting information on errors made. I need to report on which errors were overturned and who the auditor was that called the specific error. I also need to summary giving how many overturned errors each auditor has in a month. Any help is appreciated.

Thanks
J

 

[Pat Hartman]

Use a totals query.
Select AuditorID, Format(YourDate, "mm/yyyy") As OverturnedMonth, Count(Overturned) As CountOfOverturned
From YourTable
Group By AuditorID, Format(YourDate, "mm/yyyy");

or use the CrossTab wizard to create a crossTab query.