I know how to make a multi column report, over then down or Down then over.
BUT what I need is to have the report go Down then over in two columns like this
A1 A2 E1 E2
B1 B2 F1 F2
C1 C2 G1 G2
D1 D2
Where the "1" data is the name of the thing and the "2" Column is the amount .
When I use down then over the data runs down the left side and might as well not be two columns.
I want the program to count the rows, Divide that number by 2, Then run the first half of the rows in colum "A" and the rest in Column "B".
The number of rows varies month to month and facility to facility (I have 18 facilities to do this for each month.)
So that the reader can review the data in decending order by column and keep the data as close to the top of the page as possible.
Yours in inACCESSable Frustration
KniteMare
PS. I am comfortable with coding in EXCEL and at least know where to look in ACCESS if it turns out I have to write an ONLOAD event for this to work.
Any assistance or pointing in the right direction is appreciated, in advance!!
BUT what I need is to have the report go Down then over in two columns like this
A1 A2 E1 E2
B1 B2 F1 F2
C1 C2 G1 G2
D1 D2
Where the "1" data is the name of the thing and the "2" Column is the amount .
When I use down then over the data runs down the left side and might as well not be two columns.
I want the program to count the rows, Divide that number by 2, Then run the first half of the rows in colum "A" and the rest in Column "B".
The number of rows varies month to month and facility to facility (I have 18 facilities to do this for each month.)
So that the reader can review the data in decending order by column and keep the data as close to the top of the page as possible.
Yours in inACCESSable Frustration
KniteMare
PS. I am comfortable with coding in EXCEL and at least know where to look in ACCESS if it turns out I have to write an ONLOAD event for this to work.
Any assistance or pointing in the right direction is appreciated, in advance!!
