How to get more data on one page

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

Amin wrote:

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.

--
Marsh
MVP [MS Access]

AD Tejpal has a sample database that does this. You can find it he
http://www.rogersaccesslibrary.com/f...sts.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/...UBED1=ACCESS-L


"Amin" wrote in message
...
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