Example:
I used a SELECT statement to get this cursor:
ID,item,total
245,brush,5
245,pen,10
321,pen,40
321,glass,15
321,ruler,3
321,phone,25
etc.
Each ID has a few items/records.

I'd like to print labels (about 2" X 2", 3 accross) with id printed once, and all items belonging to that id:
ID= 245
Brush 5
Pen 10
and another label will be:
ID=321
pen 40
glass 15
ruler 3
phone 25
etc.

Can this be done with the label designer?
How?
Any help is greatly appreciated. THANKS ALL!