If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Horizontal Display Question
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 |
#2
|
|||
|
|||
Horizontal Display Question
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" wrote: 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 |
#3
|
|||
|
|||
Horizontal Display Question
Brent wrote:
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 Use the File - Page Setup menu item to specify how many columns you want. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How To Change default error messages | Rich1234 | Using Forms | 7 | March 28th, 2006 12:54 AM |
Linking v Embedded | Jim Bunton | General Discussion | 5 | August 10th, 2005 11:09 PM |
Another video display question | Buddyb | Powerpoint | 1 | January 19th, 2005 09:46 PM |
WORD 2002 will not display ASPX clip files. | LOUISE | General Discussion | 1 | January 11th, 2005 07:58 PM |
How do I display averages on a form. | Steve Goodrich | New Users | 1 | June 29th, 2004 12:51 AM |