Print No of Pages according to field

[SteveE]

I have a Report which I use as labels, each unit needs its own label there can be 1 to 26 or more units in total.
Could anyone offer advise how I can make the correct number of prints according a [qty] on the query/report i.e. No.of units =[10] (10 labels required) Each label whould then have its print number, 1 of 10, 2 of 10 etc. I want the operator only to have to click print and the correct number of lables to automatically be issued.

I know I need some kind of loop but am not sure how to go about it, or where it should be entered.
Any help appricated

thanks in advance
Steve

 

[SteveE]

Many thanks for your reply, I think I have the idea and will have a go.

thanks again
Steve