except for 650 students and anywhere from 6 to 10 classes per student. I'd like to be able to print up a report with a separate page for all records with matching ID's so all the 0000419 records will appear on a page, all the 407's on another page, etc, so that I can hand out to each student what books he has. How can I force the report or query to run through all the material and then not only sort, but separate for the printing? Please let me know (I'm new to databases)
Thanks for the reply. The problem I'm having (and remember, I'm new to this), is that when I look at the designview for the query, there is no "Total" row so I have no place to choose "group by" under the ID column.
thank you so much for helping me get this far. Now there is a break between ID groupings, but I don't know how to get that forced new page thing in there. I don't seem to have an "ID Footer" (though I have an ID Header) and I don't see any property called "section". When I did a search for "forcenewpage" I was pointed to a developer modeling part. Please help me with this last part...and thanks again.
I stumbled few a few things (BTW, I'm using 2007) and figured out how to add the ID Footer and eventually found the force new page setting so I set it for after section. The only problem now is that it adds a page in between so I'd eventually end up printing up twice as many pages as necessary. But this is really getting there. Thanks!