If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need Specific Data
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. |
#2
|
|||
|
|||
Need Specific Data
Access 2003 BTW.
|
#3
|
|||
|
|||
Need Specific Data
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" wrote in message ... 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. |
#4
|
|||
|
|||
Need Specific Data
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. |
Thread Tools | |
Display Modes | |
|
|