I have 5 forms (for 5 instructors). Each of theirs forms has a subform and there is a total hours in the form footer (which is a total of a number on the form and a number in the subform.

Is there any way to get a summary report or form from these 5 forms that would say:

Instructor 1 40 hrs (total in the form footer of each)
Instructor 2 10 hrs
Instructor 3 40 hrs
Instructor 4 35 hrs
Instructor 5 40 hrs

Thanks
Terry

I think you might want to reconsider your form design. What will you do if you add a 6th instructor?

Forms and reports are made from recordsets not other forms. Just make a report using the same recordsource as the form.