automate the X value of "Box X of Y"

[cavscout]

I'm trying to print box labels that contain the text "Box X of Y". The user is entering the 'Y' value on a form that queries the address information. I am stuck on trying to calculate the 'X' value for each label. The printing of the label is handeled by a report. How can I populate a table with 'X' records and then let the report print each label as a detail?

 

[cavscout]

I may have done this the long way but I developed a solution to this situation.

First, created a table with a large number of records pre-defined.

Second, created an update query that would update the table for every record <= the box count on the input form.

Third, My report pulls only the records with a box count <= the box count on the input form and that match my Sales Order Number.

Sorry if this is so vague, but if you want further information just let me know.