Repeating Details

[Guest]

Is it possible to repeat a detail section twice for each grouping...like in a
cheque stub where the payment detail section is generated twice on the body
of a page while the cheque itself is printed once.

I have built a query that shows the details and the report groups it
together but haven't figured out how to show the details a second time.

 

[Pat Hartman\(MVP\)]

You can have multiple controls bound to the same column so just add
additional controls for the stub section. Access will generate control
names like Text43. I recommend renaming such controls, especially if you
are going to add event code.

 

[Marshall Barton]

Is it possible to repeat a detail section twice for each grouping...like in a
cheque stub where the payment detail section is generated twice on the body
of a page while the cheque itself is printed once.

I have built a query that shows the details and the report groups it
together but haven't figured out how to show the details a second time.

There are a couple of ways. The best is to create a table
named Numbers with one field names NumCopies. Populate the
table with two records 1 and 2. Then use a query for the
report's record source.

SELECT table.*, Numbers.NumCopies
FROM table, Numbers

The other way is to use the detail section's Format event
along with the NextRecord property, but determining the
first time from the second time gets pretty tricky.

 

[Guest]

Thank you for responding, however, I don't think I quite get this.

so, as an example, if my query is genering the following data:

Invoice No Vendor ID
123456 1
234567 2
345678 1

I would like to see the report, which is grouped by VendorID to be like this:
----------Stub Section 1----------
Invoice No
123456
345678

----------Stub Section 2----------
Invoice No
123456
345678


Cheque Body.....
-----End of Page------------------

If I am not misunderstanding adding the 2 controls bound to the same field
will result in two copies of the stub?

This is going to be printed on cheques and thus Stub 2 and the Cheque body
will go to the vendor. Stub 1 will stay with our records.

 

[Guest]

I like the numbering one...thanks.

There are a couple of ways. The best is to create a table
named Numbers with one field names NumCopies. Populate the
table with two records 1 and 2. Then use a query for the
report's record source.

SELECT table.*, Numbers.NumCopies
FROM table, Numbers

The other way is to use the detail section's Format event
along with the NextRecord property, but determining the
first time from the second time gets pretty tricky.