Report by month, totalling different res

  • Thread starter Sue R via AccessMonster.com
  • Start date
S

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
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Multiple Tables 1
Page numbering with Merged Document and IF statements 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Template with fields and premade texts.. 0
Combining two fileds of information in the legend of a bar chart. 4
Summary Report 2
Grouped/Sorted Report by Month 1
Dividing totals created by check boxes 1

Top