On 2 Dec 2005 11:45:12 -0800, "Bruce Lawrence" <BL*****@gmail.com> wrote:
Access 97, trying to print on Avery 5260 label sheet.
I used the label wizard and told it the query to use. The results give
me what I want on the label however when I hit print or print preview,
all I see is 1 label in the upper left corner. Why isn't the entire
sheet filled with the same information as what is in the first label?
I want every label to ahve the same information in it.
Thanks
You can used a query with a cartesian join.
Create a table (tblLabelNos) with one field (LabelNo) and add one record for each lable you want to print.
1,2,3,4.....30
Add this table to the recordsource of the report with no joins to any other table.
When the report is run, the recordsource will return one record for every record in tblLabelNo's. You can adjust how
many copies of each lable are printed by controling the number of records in tblLabelNos.