label wizard question

[Guest]

I have a report/label being generated based on the results of a query - and
it works fine.

But sometimes I need many copies of that one label - like 12 or so. I
really don't want to print 12 times and use just one label per sheet and
leave all the rest un-used.........Does Access' label feature have the 'make
new sheet' like you find in Word's mail merge? I haven't been able to find
it and I was wonder how someone might accomplish this.

 

[Rick Brandt]

I have a report/label being generated based on the results of a query
- and it works fine.

But sometimes I need many copies of that one label - like 12 or so. I
really don't want to print 12 times and use just one label per sheet
and leave all the rest un-used.........Does Access' label feature
have the 'make new sheet' like you find in Word's mail merge? I
haven't been able to find it and I was wonder how someone might
accomplish this.

Create a table with one number field and enter the numbers 1 to 12 in it. Add
it to the query used by your report and make NO join line to it. Just like that
every row in your old query will be duplicated 12 times in the revised query.

If you wanted only 6 copies you just put <7 as a criteria on the number field in
the new table. You can even get fancy and pull that criteria from a form so
that the number of labels is configurable without modifying the query.

 

[Guest]

ah cool....as soon as I read your advice it made sense....need to trick the
query rather than rely on the report/label feature.....mucho gracias