Summary Report

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I have a table for reporting errors. I have a field called TOE (Type of
error) I want a summary report that will give me total number of errors, and
the say how many are of what type.

i.e. the TOE field gets its values from a drop down on a form and can only
be one of a possible 7 values.

So the report might say 10 errors made up of Hardware 4, Email 3, Internet 3

Can someone point me in the right direction for creating such a report?
 
Keith said:
I have a table for reporting errors. I have a field called TOE (Type of
error) I want a summary report that will give me total number of errors, and
the say how many are of what type.

i.e. the TOE field gets its values from a drop down on a form and can only
be one of a possible 7 values.

So the report might say 10 errors made up of Hardware 4, Email 3, Internet 3
Click to expand...


Create a Totals type query something like:

SELECT TOE, COUNT(*) As ErrorCount
FROM thetable
WHERE whatever
GROUP BY TOE

Then a report based on the new query should be trivial.
 
Back
Top