Need Specific Data

[Nurse Matthew]

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.

 

[Nurse Matthew]

Access 2003 BTW.

 

[Al Campagna]

Nurse Matthew,
You don't indicate what your working on. (form, query, report?)
A report solution (of many solutions available) would be one Sorted and
Grouped on Attendance.
The Attendance footer for each Attendance type would contain...
= Sum(Attendance)
and would yield the total for each Attendance type.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Duane Hookom]

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/Forums/en-US/addbuz/threads?