Report by month, totalling different res

[Sue R via AccessMonster.com]

I have a table with (among other fields) a date field and a status field
which is coded by different numbers.

Ex - if the Status is 1, it's a Pass, if it's 2 or 3 it's a Fail, if it's 4,
7 or 8 it's Other.

I want a report that will display by month, the total number of each Pass,
Fail, or Other and then the total number (pass+fail+other) by month.

Any help is appreciated. Thank you.
Sue

 

[Guest]

Add a field to your status lookup table to store Pass, Fail, or Other for
each unique status value. Then create a totals query that joins in the status
lookup table.

Group By an expression like Format([DateField],"yymm") and the
Pass/Fail/Other fields. Count the Primary Key field for your total number.

In your report sort/group by YYMM and display a group footer. Add a text box
in this footer to total all stati for the month.