I am taking input from 2 forms. One to take details of students, the other to take details of instructors. Each student is allocated to an instructor, so I have 3 views. One is a table of students. A second is a table of instructors, and a third is a reduced view of the instructors to show only one field other than name, that is a number of private students the instructor has.

What I really want to figure out is how to add that number to the count of current students. Currently I have to use a view and a report separately and then work out the sum. As the attached image shows, this is a bit of a haphazard approach and am open to suggestions as to a better approach.

I am relatively new to this so be gentle!!

Cheers.

Adam 

PS Thanks for all the help so far...very helpful forum