Print out Query Multiple Times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
Can someone please help me with this. I have created a query for my database that gives me the exact results I need based on the entered parameter value. However I need to print this result many times on 8 1/2" x 11" paper to be cut and used as inserts for a product. The amount of times and the size of the result block varies with each product. Besides copying the records and pasting them on by one into an excel file (which takes forever) is there a way that I can have the query results print out multiple times? Or is there a way to paste something multiple times (ie 100 times) without having to do it manually
Thank you so much for any help you can provide
Christine
 
It can be done. You need an additional table something like

tblNumbers
fldNumber

Create records from 1 to the maximum number of copies you need.

Now open your query and add tblNumbers to the tables in the query and add the
fldNumber to your query.

This will return one row for every combination of the fldNumber and your other
data. To restrict it, you will need a where clause that references a number in
your data - number of copies required??

Field: fldNumber
Table: tblNumbers
Criteria: <= [MainTable].[NumberOfCopies]s
 
Back
Top