Create a query like
SELECT ATTENDANCE, Count(*) as NumOf
FROM tblNoNameGiven
GROUP BY ATTENDANCE;

Use this query as the Record Source for your report.

If your report needs to display both detail information with this summary,
use the new report as a subreport in the Report Header or Report Footer
section.
--
Duane Hookom
Microsoft Access MVP

NOTE: These public News Groups are ending June 1st. Consider asking
questions at http://social.answers.microsoft.com/...ddbuz/threads?


"Nurse Matthew" wrote:

I want to be able to count data in a field in my database. The field is
called ATTENDANCE.
Under attendance are options like ATTENDED and REFUSED and SICK etc.

I want to sum up all of a persons attendance on a report to show they
attended 6 classes, refused 2 classes, etc.

It seems this should be a lot easier than I'm making it out to be.