Printing one label for multiple records

[dharman]

I am trying to print one label that will include data from multiple
records. I have generated a query where each record has some common
fields and some unique fields. Can a label be generated through
reports that will pull the common info once and the unique fields
multiple times? What am I missing?

 

[Guest]

Yes.

Create a report and bring in all the fields you want to include in the
report/lable.
At the top of the screen click the sorting button and select the field you
want to use as your "common info"
Ensure you select the group header and footer options in this box to "yes"
Close this menu.
Drag the "common info" object into the field header area of the screen.
Arrange the rest of the fields in the Detail section of the screen
View the report.

Is this what you are looking for if not let me know.

 

[Guest]

Yes.

Create a report and bring in all the fields you want to include in the
report/lable.
At the top of the screen click the sorting button and select the field you
want to use as your "common info"
Ensure you select the group header and footer options in this box to "yes"
Close this menu.
Drag the "common info" object into the field header area of the screen.
Arrange the rest of the fields in the Detail section of the screen
View the report.

Is this what you are looking for if not let me know.

 

[dharman]

I am able to see the results I need in a report. I just can not get
the results for a label, which is what I need. Is this possible?

 

[dharman]

I am able to see the results I need in a report. I just can not get
the results for a label, which is what I need. Is this possible?

 

[Rick Wannall]

In every way, a label is in fact just a report with a little bitty page
size. When you say that you cannot see what you want in a label, are you
saying that the Access report you are using to print your label will not
show the same thing as some other Access report you use to print the same
thing?

 

[Rick Wannall]

In every way, a label is in fact just a report with a little bitty page
size. When you say that you cannot see what you want in a label, are you
saying that the Access report you are using to print your label will not
show the same thing as some other Access report you use to print the same
thing?