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.

Thanks,
Scott

Scott,

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]))

HTH

John

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

Regards,
Scott

No Problem glad to Help out!