I'm trying to create a small database that will create chart lables for patient chart.

I need it to be able to print 3 labels at the time for a patient on 1 x 4 inch labels that are 2-up/2-across on a sheet.

Is there a way to do a report like this? I can get the data in, but not sure on how to make the report to repeat the record .

Thanks,

Patrick

Hi Partick

In the form design you can set up all 3 labels on 1 report and put the field in 3 times, however this will waste 1 label per sheet

Richard

But with them being two per row, then if i do three, unless i can start the 2nd record in the 2nd label on the 2nd row, then i'm wasting 5 lables per page or one every other row.

Sorry, I misread the 2-up/2-across thinking that the label sheets were only 4 labels per sheet.

Ok then how about turning the label sheet over and inserting so the report prints on the unused labels 2nd pass (this would leave 2 labels unprinted) - surely these could be used for something if left in a spare box?

Rich

There are 20 labels per sheet, and i wish the customer i have would just use 4, that would be easy to fix, but they don't want to do that, they want 3, so i'm trying to get the most labels on a sheet that I can.

If i do, 2 labels on the first row, then 1 on the second row, then go to the next row, then i will waste 5 lables per sheet,

If i can start the 2nd record on the 2nd row, 2nd label, then i'll lose 2 per sheet.

Some one, I think it was Peters Software had a utility to print unused lables which might work for you. I checked the LinkDb but his link isn't working. maybe do a search on Google for his site.

I have used this code to do what you want:

Skip used labels and print duplicate labels

There is a link there to an access 97 reports sample MDB with the code.

Hi Boyd,

That was the code I was thinking of.

Thanks for the link.

Your welcome.

Glad I could help.

:uarulerz: