Query in a Report

[gonzojm]

I have 70 different schools in a table and over 1000 records of student's names.

I want to create a report for each school listing the student's names sorted by grade, whether they are attending college, and their last name.

Besides doing this the long way (creating 70 queries for each of the schools), is there a much simpler way to get this information in a report?

I want a page break after each school's information.

Thanks for your help. Please reply simply so I can understand what I need to do. Thanks again!!

 

[Bry12345]

You can design the report to group by the school field. In Access 2000, go to View, Sorting and Grouping. After selecting the school field to group on, you should add either a group header or footer. The Group header can be used for column headings.

Headers and footer also have their own properties. To keep your school information separated by school, you can set "force new page" properties for a header or footer, so that when the report prints, each group starts on a new page.