same recordset subreport side by side

[novreis]

I inherited an access application and i need to have the same recordset of a subreport in two areas side by side, in same page. For instance, I retrieved 45 records, I have in left side of page, place to 20 records and on the right side other 20 ( so the 21 to 40 records will be the right side ). The other 5 will be on the next page.
Thanks

[novreis]

I swear that I googled a lot to find a solution. I need just a tip. It is too easy or too difficult, or my english is not understable?
As you understand I am new here and also to Reports.
Thanks for any tip to google it.

[novreis]

I understand why no posts. Easy solution in spite of a bug in acess 2000 that I discovered in

http://support.microsoft.com/kb/208364/en-us?fr=1

Solved

[RuralGuy]

Did you want to share your solution with the others that read this forum?

[novreis]

Hi RuralGuy,

The solution is inside the link I posted but I can resume ( I am using access 2010 to access the 2000 mdb) what I did

0 - the header and detail must be designed to fit in half page
1 - opened the subreport in a new window ( mandatory?)
2 - dragged the right side of the subreport till the last column of the page ( the header and detail remain fixed at left side )
3 - choose Page Setup tab
4 - clicked "Columns" and inside I choose "2 columns"
5 - choose Column Layout ( Note - in access 2000 you must use the sugestion in the link I posted )

"problem I did not try to solve - the header appears only in the left side )

[RuralGuy]

We appreciate you taking the time to post back with your solution. Thanks again.