I need to know how to print multiple labels for each customer and also to
have the text fore color for certain customers = to a certain color. I would
appreciate any help that someone may have.
One handy way to print a variable number of labels is to use an
auxiliary table (which actually comes in handy for several things).
Mine is named Num, with one long integer field N with records entered
for 0 through 10000 or so (more labels than you will ever want to
print).
In the Label report, include the Num table, and don't put ANY join
line. Instead put a criterion on N of
< [How many labels?]
or, if you have a field NLabels in your query indicating the number of
labels for that customer, just
< [NLabels]
For the color, I'm not certain that it works on a Report but take a
look at the "Conditional Formatting" option on the Format menu item.
John W. Vinson[MVP]
