Prev: Merge a field data for all records in a table into one output
Next: Opening Report Closes Database
From: Nurse Matthew on 3 Jun 2010 10:27
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.

From: Nurse Matthew on 3 Jun 2010 11:07
Access 2003 BTW.


From: Al Campagna on 3 Jun 2010 11:13
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."


"Nurse Matthew" <NurseMatthew(a)discussions.microsoft.com> wrote in message
news:2E58A8CD-F18C-42BF-965F-A734BD4E8C85(a)microsoft.com...
>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.
>


From: Duane Hookom on 3 Jun 2010 11:29
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?


"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.
>
 | 
Pages: 1
Prev: Merge a field data for all records in a table into one output
Next: Opening Report Closes Database