print multiple labels

[Guest]

I have a database put together for a collection of books. I have made labels
using the label wizard to create labels with a unique number assigned for
each book that I will place inside each book. But, I have multiple copies of
some books. So, my question is, how do I say "Book # - Copy #" on the label?

Thanks!

 

[John W. Vinson]

I have a database put together for a collection of books. I have made labels
using the label wizard to create labels with a unique number assigned for
each book that I will place inside each book. But, I have multiple copies of
some books. So, my question is, how do I say "Book # - Copy #" on the label?

Thanks!

One handy way to do this is to have a field in your books table indicating how
many copies you have. Create a little auxiliary table named Num, with one
integer field N; fill it with numbers from 0 to the maximum number of copies
you'll ever have. This table can be used in many contexts - I routinely have
one with values 0 through 10000.

Include Num in the label report's recordsource query with NO join line.
Instead, put a criterion on N of

< [Books].[Copies]

You can then put a textbox on the label report with a control source

=N + 1

and label it Copy.

John W. Vinson [MVP]