Need to set up a query to save labels

smackedass · Nov 16, 2003

Hello

I have to print three sets of labels for 20 people. I can simply do that,
straight out, but since there are 30 labels per label page, I'd be wasting
10 labels per page, unless I wanted to give them to my daughter to play
with.

How can I set up the query (or can I do this at the report level, which is
drawn from the query?) so that I can print each "batch" of labels one
immediately after another, without wasting any labels?

Thanks again.

smackedass

smackedass · Nov 16, 2003

It is also relevant to my question to mention that the 20 people are the
same 20 people that need mailing labels for each "batch" of labels.

smackedass

Douglas J. Steele · Nov 16, 2003

FredG has posted one solution in the past. Take a look at
http://www.google.com/groups?threadm=1tD09.6282$pg2.539199@bgtnsc05-news.ops.worldnet.att.net

(watch for word-wrap on that URL: it's supposed to be all on one line)

I think that Litwin, Gunderloy, Getz et al have a solution in their Access
Developer's Handbook as well. See http://www.developershandbook.com/ for
more information about their indispensible books.

smackedass · Nov 16, 2003

Thanks, I'll give this a try!

smackedass

Douglas J. Steele wrote in message ...