Print records 3up

[needafix]

I need to create a report that prints labels three up. I can use VBA to keep track of the records but I need to cause the application to print the just formatted labels before moving on to the next set of records. Does any one have any experience or ideas on how to do this? Any help will be appreciated.

[NTC]

prints labels three up

?? I don't understand what that means.

[needafix]

I need to print 3 labels across the sheet (a row) and then print the next three. This is the way the are laid out on the Avery Labels #5160. They are 3 accross and 10 rows in the page. The pages are 8.5 X 11. I need to read 3 detail records (or however many are left in the group) and then print those on the row of labels before reading and processing the next records. I hope this makes sense.

[ajetrumpet]

prints labels three up

?? I don't understand what that means.

3ups and 8ups are sticky labels that are used in a lot of retail environments. they are precut on the avery sheet

[NTC]

Access, in Report creation, has a Label Wizard.

First you make the 'record set' - either a query or a table that contains all the records that you will want printed.

Then create a report using the label wizard - which will step you thru set up including selecting the Avery product ie. 5160 which is embedded information in this feature.

[needafix]

Well is this ever simple. I haven't been using the report wizard - just creating report in design mode and using VBA. I checked out the Label Wizard which is right there on the first screen and it looks pretty straight forward. Thanks very much for you help.