How to get more data on one page

[Amin]

So I have two columns:

Date Workloads


When I pick a large date range, this results in multiple pages for the
report, but leaves a lot of empty space on each page. What I want to do is
have the data continue in a column on the right like this:

Date Workloads Date Workloads


This would save me having multiple pages, as well as not having so much
empty space on each page.

When I tried to just copy/paste the field box, this just resulted in the two
sets of columns being identical. Any suggestions?

Thanks,
Amin

 

[Marshall Barton]

So I have two columns:

Date Workloads


When I pick a large date range, this results in multiple pages for the
report, but leaves a lot of empty space on each page. What I want to do is
have the data continue in a column on the right like this:

Date Workloads Date Workloads

With the report open in design view, use the File = Page
Setup menu items. You can then set the report to use
multiple Columns. You will probably want to uncheck the
Same as Detail box and set the column width yourself.

 

[Roger Carlson]

AD Tejpal has a sample database that does this. You can find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=39

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L