Unanswered: Printing Number Labels from a Single Record
I have a data table that contains item information such as an item number, description, and lot number and number of units in the lot. From with Access I need to generate a set of labels that shows the item number, description, and lot number and consecutive numbers from one to the number of units in the lot.
Currently I am doing this by using a VBA procedure that writes a tempory table with an identical record for each unit in the lot and then running a report from this table using the page numbering to generate the unit numbers. However, this seems likes a very slow and complex method to solve the problem. Is there a better way to accomplish this task.