Access report - 2 "Groups" per page

[appelq]

I have a report, "Winning Bidders" for a silent auction.
The table "Baskets" has Basket#, Name, Winning Bidder, Amount Bid.
the report groups on [Winning Bidder] and shows each basket they won, and prints a Total Due in the Group footer.
the total number of won baskets for any bidder will be small, 5-6 tops. I want to have the report print 2 Winning bidders on each page so we can easily cut each page in two and hand the bidder the slip for check out.
Imaging an 8.5 X 11 page cut horizontally in half.
the top half has Bidder#1, The bottom has Bidder#2, etc.
Ideally there would be a "Cut Line" printed between the two bidders, and always at the half page spot (5.5" from top).
Alternatively, if the report could print in Landscape, with 2 Pages printed per Sheet of paper, I could format the report to be only 5.5 in across in "Portrait" mode...
Ideas?

 

[dhookom]

If I understand correctly the 1/2 page may contain anywhere from 1 to 6 records. If so, consider creating a Main Report based on unique bidders and add a 5" high subreport in the detail section. Don't allow the subreport to either grow or shrink. Add a line at the bottom of the section. If you don't want a line to show, you can hide or display the line based on the odd or evenness of the record in the detail section.

Duane
Hook'D on Access
MS Access MVP

 

[appelq]

Need a little help.I think I am close.
I have a Sub-Report named rptWinningBids
I groups on Bidder No. and
BIDDER Header ----
Bidder - #1
rpt body ------
Basket# , Basket Name, winning Bid Amount
BIDDER footer ---
Running Sum Bid Amount_______
Rpt End-------

I want that to print Bidder number 1 on the top half and bidder #2 on the bottom have of the "Master Report"
So in the "Master report", The record source for the Master report is SELECT Bidder_ID from Baskets order By Bidder_ID, order by Basket_No.

In the detail section, I added the "Sub-Report control and set it to get the original report rptWinningBids
I have the Detail section on the Master report set to 5" and the Can Grow and Shink are both NO

I set the Sub-Report Object on the master report to Can grow and shrink to both NO.

The result is that I get multiple rows on each half of the paper, and the 2 test sets I have repeat in both halves.

???

 

[dhookom]

What's the record source of your main report? I think you want something like:

 SELECT Bidder_ID from Baskets GROUP BY Bidder_ID;

Then set the link master child properties to Bidder_ID. You can then put the Bidder information on the main report and possibly delete the Bidder group header in the subreport since it would be redundant.

Duane
Hook'D on Access
MS Access MVP

 

[appelq]

Never mind my last post.
I didn't have the mast and sub-forms linked properly.
Works Great! thanks.