Print Report Records Twice on One Page

[Lydia]

I have a report that prints one record per page. I want to copy each record and print it twice on each page - so half the page can be kept and the other half given to the customer as a receipt. How can I do this? Thanks.

 

[Trevor G]

Welcome to the Forum,

All you should need to do is in the design of your report is select the items in the detail, then extend the detail section and copy and paste so you have the same items repeated twice.

You can also place in a line to devide the 2 parts.

 

[Lydia]

I am afraid that only duplicates the data. Do you know how to also show the headers twice so it looks like the whole report is duplicated for each record?

 

[Trevor G]

Try doing the same with the headers so you are using the detail section for everything.

 

[DCrake]

Create a table with 1 field in it called Copies.

Add 10 records

no's 1 to 10

Create a new query and bring in the table/query that is the recordsourc for your origninal report.
Next add the table decribed above.
Do not join the two tables.
Bring down the field Copies from the table and place <3 in the condition row.
View the query in datasheet mode and you will see two copies of each record.

Save this query and use it for the recordsource for your report.

You can then use the copies value to control the number of copies required.

 

[Lydia]

Thanks but I am still not quite there. I have now got the record repeated in the query and hence in the report. Do you know how to get the record headers repeated too? When I just copy them on the report I get:

Header
Header
Record 1
Record 1

What I want is:

Header
Record 1

Header
Record 1

Thanks.

 

[Trevor G]

I suggested that you take your page header and place them in the detail section.

They will repeat for each record that is shown, so if you do as I suggested you will have your answer.

See attached sample.

Open the database you will see a form, it has a button when you click it will preview a report showing the single record twice with the headers and a line dividing them

 

[stopher]

Thanks but I am still not quite there. I have now got the record repeated in the query and hence in the report. Do you know how to get the record headers repeated too? When I just copy them on the report I get:

Header
Header
Record 1
Record 1

What I want is:

Header
Record 1

Header
Record 1

Thanks.

If you are using DCrake's solution then you just need to add a group/sort on the copies field at the top level in your report.
Chris

 

[Lydia]

Thanks very much for your help. Using the copy query and grouping has worked a treat. I'm sure you'll hear from me again soon when I stumble upon my next problem!