Have two columns of data from details section

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a section in my report that comes from a list of products and their
prices. The names of the products and prices do not take up much space
horizontally on my report but there are usually 15-20 of them which means
they take up space vertically. I am trying to save space on my report and
would like to create two sets of columns in my detail section. So what I
want is to have Product Name and Price for about half of my products appear
on the left and then the other half of them appear on the right. Is it
possible to do this or is this beyond the capabilities of access?

Thanks,
 
Hi,

I have a section in my report that comes from a list of products and their
prices. The names of the products and prices do not take up much space
horizontally on my report but there are usually 15-20 of them which means
they take up space vertically. I am trying to save space on my report and
would like to create two sets of columns in my detail section. So what I
want is to have Product Name and Price for about half of my products appear
on the left and then the other half of them appear on the right. Is it
possible to do this or is this beyond the capabilities of access?

Thanks,
Click to expand...

You can have Access print out the report in columns.
File + Page SetUp + Columns.
 
Fred,

Thanks for your help. Is there a way to make this apply to only the details
section of the report and not apply to the page header.

Thanks,
 
Fred,

Thanks for your help. Is there a way to make this apply to only the details
section of the report and not apply to the page header.

Thanks,
Click to expand...

Yes.
Make the Width of the report the full width wanted.
Make the controls in the detail section just the size of one column,
or less.
Then File + Page SetUp + Columns, Uncheck the Same as Detail check box
and enter the width and height of the wanted column manually in the
appropriate boxes.
 
Back
Top