Two Records, One Label

[ArcherSteve]

Is it possible to print two records on one label? I have to print 200 numbers onto labels for ID purposes and I don't want to waste 200 labels if I can use 100.

For example, I need the first label to be:

BACKNUMBER          BACKNUMBER
     1                   2

and the second label to be

BACKNUMBER          BACKNUMBER
     3                   4

etc....

They are standard size Avery mailing labels. Any ideas?

Thank you in advance.
-Steve

 

[Uncle Gizmo]

Printing two records on one label

You will only be able to print one record on one label.

So the best approach would be to get all of the information into one record.

You could do this by having two queries one to extract all the even numbers and one to extract all the odd numbers. This has been done before and I'm sure there is information within the forum on it.

Once you've got that working correctly, then you need to combine the two queries together to produce a query with the display you require for the label. I'm not 100% sure that this will be successful but I'd give it a try it won't take too long to find out.

This is the hard part and will take the time unless you can find previous code somewhere else.
I can foresee one problem, and there are probably a few more! If the length of your text varies, then the print position will either move left or right of center, so you will also need some way of checking the number of characters and adjusting the gap to suit. I'm pretty sure I have seen this problem solved before.

This will probably restrict you to using a fixed spaced font like Courier.

 

[ArcherSteve]

Thanks Gizmo, I'll go try that out.