Using Access 97 I am trying to create some address labels.



The labels need to contain:-
Company Name
Address
City
State
Postcode
Box Numbers (1 of 4, 2 of 4 etc)



I've designed a form for selecting the company and entering the total number of boxes. The record has also been created. Using the form I choose the company and enter the total number of boxes. The form is linked to a query. This puts the company name, address etc and the total number of boxes on to the report.



The only thing I cannot get to work is the box numbers (1 of 4, 2 of 4, 3 of 4, 4 of 4)
It will put the " of 4" (which is entered on the form) but i don't know how to get it create the other number, nor to produce the correct number of stickers (In this example 4)



Any help with this would be greatly appreciated