Summary Report

[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?

 

[KARL DEWEY]

Use a totals query.

 

[Marshall Barton]

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

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.