How do I print full page of same label in Access?

[Guest]

I need to print a full page of the same label in Access. Right now, I have 10
to 12 records in my table. I want each record to print out on one full page
of labels so I have record #1 on all 40 labels on the first page, record #2
on all 40 labels on the second page, etc.

 

[Duane Hookom]

Add a table/query with 40 records to your report's record source. Don't join
it to any other table.

This is generally done with a table of numbers from 1 to 100 (or more) that
allows you to set a criteria under the number column to:

<=40

 

[Guest]

One way you can do is you can do the filter in the report properties for each
record.

 

[Guest]

I do not follow. I am just starting to work with Access and have much to
learn. Can you list step by step instructions on how to do this?

 

[Guest]

How can you do that? Please list steps.

One way you can do is you can do the filter in the report properties for each
record.

 

[Duane Hookom]

Create a table "tblNums" with a single, numeric field "Num" and add the
values 1 through 50.
Go to the design view of your report and find the Record Source property.
Open the record source which will be a query.
Add the new table "tblNums" to the query.
Add the Num field to the grid.
Add a criteria under the Num field of:
<=40
Close the query design view and update answer yes to update the report's
record source.
View the print preview of the report. You should see 40 copies of each
record.

 

[Guest]

I did exactly what was written. When I went to print preview, it brought up
every field of my original record source and wanted me to enter criteria for
every field. My labels are not mailing labels, but are nutritional labels
that I am placing onto mailing labels. The system wants me to enter calories,
fat, etc. manually instead of reading what is in my record source. Do you
have any other suggestions?

 

[Duane Hookom]

You need to provide for us the SQL view of your report's record source.

 

[Guest]

Never mind. I figured it out. Thanks for all your help.