Print record twice on 1 page

  • Thread starter Thread starter Mario M
  • Start date Start date
M

Mario M

Hi there ,

I have records with a date field.
For each date there are several records.

I'd like to print ( or show) each record ( per date ) twice on 1 page.
Is this possible and if yes , how do I create the report ??

Thanks for your help.

Regards
Mario
 
1. Create a table named (say) tblCount, with one field named CountID, of
type Number. Mark the field as the primary key. Save. Close.

2. Enter two records into the table. Use the numbers 1 and 2 for the 2 rows.

3. If the report is based on a query, open it in design view. If not, create
a query based on the report's table.

3. Add tblCount to the query. If you see any line joining the 2 tables in
the upper pane of the query design window, select the line and delete it.
There must be no join between the 2 tables.

4. Set this query as the RecordSource for your report.

The report now gives 2 records for each entry.

You can extend this idea to choose the number of records to be printed when
the query is run. See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html
 
Back
Top