Want to create a report that includes all people with a common field on one page

[ascottharrison]

I'm very new to Access but am familiar with Excel.

I have imported data field from a spreadsheet that show students who have subscribed to our school newspaper. Fields include first name, last name, and name of 1st Period teacher. I would like to create a printable report that shows all student subscribers who have teh same same 1st Period teacher so that we can sort the correct number of newspapers to be delivered to each teacher. This report needs to list the names of the students for that class and would ideally provide a total number to count out for that teacher.

I would like the report print so that a different page is printed for each teacher.

- Scott

[June7]

Use report Sorting & Grouping features. Set ForceNewPage property for the teacher group footer.