Mar 28 2005, 05:25 PM
I have a table name Students and another one named Attendance. This is a one to many relationship. The attendance table has 3 fields. Student ID - a foreign key which references the primary key from the students table. It also has a Month field and hours per month field.
Ok here's the case:
Say I want to get a total of how many hours for all of the months that a student is in attendance, and get this result to show up on a report. How would I do this?
Any help would be appreciated.
Mar 28 2005, 07:24 PM
If you have your grouping on your report to StudentID with a studentID Header AND footer in the StudentID footer place an unbound control caption: Student Hours Control source: =Nz(Sum([nameofyourfieldthat holds the hours])). Then in the report footer place another unbound control Caption: Grand Total Student Hours, Control Source: =Nz(sum([nameofyourfieldthatholds the hours]))
Apr 4 2005, 06:22 PM
Hey sorry that I took so long to respond, I've been very busy this past week. Putting the SUM function on the report worked perfectly. I appreciate the help.
Thanks a million
Apr 4 2005, 06:31 PM
No Problem glad to Help out!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here