how to group detail records for mailing lables

[pampolk]

I have a query that returns the below results (I am using a small sample of data):

levelid levelname bookid title
1 A 974 A zoo
1 A 500 Aaron and Steve
1 A 765 Amazing Animals
1 A 257 Avengers
1 A 430 Avery and me
1 A 789 Boys are smart
1 A 497 Zebras

I need to create labels using the data from the above query. Specifically I need to print on each label the level name AND four titles, then on the next label the level name AND the NEXT four titles, and so on for all of the titles related to level A.

I need to use Avery 5161 (1x4) 2 across

There are a total of 65 titles that are related to level A. Please note this can vary as more data is entered and the labels will be rerun every two months.
--
--
So using the above data as an example the labels would need to look like:

LEVEL A LEVEL A
A Zoo Avery and me
Aaron and Steve Boys are smart
Amazing Animals Zebras
Avengers

I can get the above(somewhat) to work in a report but I have to page break after every four records.

If anyone can let me know if this can be done or point me in the direction to start this - thank! I do want to learn how to do this.


Thanks very much.

Pam Polk