2 Records on one report

[Simon Harris]

Hi All,

I have a report for printing invoices, which works great. The invoice only
takes up half of one A4 sheet when printed. My customer wishes to print two
invoices per sheet. Is this possible? Can I put a 'repeat section' or
something like that in place?

Thanks!

--
-
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!

 

[Al Campagna]

Simon,
Create a table called tblCounter with just one numeric byte field called Counter.
Populate the table with just 2 records...
Counter
1
2

In the query behind your Invoice report, include tblCounter... with NO relationship
to your Invoice table/s. Include the field Counter in the query grid.
This is called a Cartesian relationship. It will cause 1 invoice to repeat itself... one
with Counter = 1 and one with Counter = 2.
Now use Counter as a Grouping value on your report.
Use the Counter Header area for any textual info. (CompanyName, Address, Date, etc...)
Use the Detail section for your actual Invoice items. (multiple items)
Use the Counter Footer area for Invoice totals. (total due, discount, etc...)

 

[Simon Harris]

Thank you!

Simon,
Create a table called tblCounter with just one numeric byte field
called Counter. Populate the table with just 2 records...
Counter
1
2

In the query behind your Invoice report, include tblCounter... with
NO relationship to your Invoice table/s. Include the field Counter in the
query grid.
This is called a Cartesian relationship. It will cause 1 invoice to
repeat itself... one with Counter = 1 and one with Counter = 2.
Now use Counter as a Grouping value on your report.
Use the Counter Header area for any textual info. (CompanyName,
Address, Date, etc...)
Use the Detail section for your actual Invoice items. (multiple items)
Use the Counter Footer area for Invoice totals. (total due, discount,
etc...)

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions