Horizontal Display Question

  • Thread starter Thread starter Brent
  • Start date Start date
B

Brent

I have a report that contains a form header, Detail Section, and Form
Footer. Today the report produces account number and Amount in the below
listed format.

Account# Amount
11111 $100
22222 $200

This information is contained in the detail section of the report.

Is there a way to have this information present in the following format? In
more of a Horizontal format before going to a new line. I would like to
have it show 4 sets of data across before going to the next line? any
Ideas?

Account# Amount Account# Amount
11111 $100 22222 $200


Thanks for any input.

Brent
 
I'm no reporting expert but the only way I know to do that is to format the
data that way before the report is opened by creating a table with the data:
Account1
Amount1
Account2
Amount2 etc. etc.
You need a VBA procedure that opens a recordset on the original table or
query and loops thru the data writing another table in the above format. You
then use this new table as the source for your report. Its very easy to do. I
use that technique for many complex reports.

Dorian
 
Brent said:
I have a report that contains a form header, Detail Section, and Form
Footer. Today the report produces account number and Amount in the below
listed format.

Account# Amount
11111 $100
22222 $200

This information is contained in the detail section of the report.

Is there a way to have this information present in the following format? In
more of a Horizontal format before going to a new line. I would like to
have it show 4 sets of data across before going to the next line? any
Ideas?

Account# Amount Account# Amount
11111 $100 22222 $200
Click to expand...


Use the File - Page Setup menu item to specify how many
columns you want.
 
Back
Top