Multi Page Report Question

[Ricardo]

Trying to create a report/db/form where I can enter a set of information and
then produce Folder/File Covers for this information, but in a way where I
can select the number of folder covers I want to print out and it will
automatically generate 3 pages each with Folio 1, Folio 2 etc etc.

Details are as below.

Primary Key
Car Name
Maintenance Name
Maintenance Dates

I would then create and entry for the above columns for example:

1 | Honda | Defect Rectification | Jan 09 - Feb 09

I would then have an entry for this item. Then, as part of the report, it
will come up and ask me how many "covers" I would like to create, then create
the pages, each numbered sequentially with Folio 1 etc and then I would be
able to print it out.

Please let me know if this is confusing as I will try and explain it better.

 

[Allen Browne]

How about adding a field for the quantity to print?

You can then use a Cartesian Product query to generate a record for each
cover. Details and example in:
Print a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html