I would like to know how to print one label and one label only from a
mishap database. When I try to get my results I get a page full of
the same label. I will use this label to identify the mishap report
folder and the folder contents. I set my query from my form
[forms]![myform]![mymishapnumber]but when I go to print mymishapnumber
I get 50 labels to print off of th esame number. I only want one
label. My labels are set for one column.

Now for the second part of the question providing the first question
gets answered. Since I only need one label at a time and I dont want
to waste my sheet of labels. How could I tell the machine to print to
label 2 (column 1, row 2 or column 1, row 3 etc.) because the other
labels have been used previously. Thank you!

The report that prints labels gets them for a table/query.
The first time create your table with the info in record 1 and blank
records for the 49.
Next time create it with the info in record 2 and blank record 1 and
then blank in 3-50.
You can even get elaborate and keep track of this automatically, going
back to one when you finish the sheet.

You could also do it with a just a counter table with one record with
a number from 1 to 50 and some code in the report, but you would need
to know the where to put the code which is not obvious.

I think fhe first solution is ugly in a way but easier unless you are
a programmer.
Good Luck
Ira Solomon

On 14 Jul 2003 18:00:39 -0700, vegas18 (AT) joimail (DOT) com (Mike S.) wrote: