I have a report that pulls information from approximately 200 records, and displays information from each record in a 5.5" x 8" area. Information from two records are displayed per page. The records' information is currently sorted alphabetically by a value in one of the records' fields. I've recently had a request to print the report in booklet form, and after some research I've determined that the best way for this to work is to change the report sort order to booklet style (so instead of 1 2 3 4 5 6 7 8 order, the records would be in 1 8 2 7 3 6 4 5 order). Further research leads me to believe a macro might be the only/best way to do this, but I'm unsure whether macros can actually do the job. Also, while I'm comfortable with programming in general, I have no experience with Access macros.
My questions, then, are the following. Is there a way to obtain the desired print order? If so, are macros the best way to do this? And if so, can anyone point me to a good getting-started guide to Access macro programming, especially relating to this sorting issue?
Thanks!