Multi-Column Report, Down then Over

[KniteMare]

Multi-Column Report, Down then Over
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!!

 

[Trendsetter]

If the 2 columns you are trying to run together are different data fields then I don't see there should be a problem.
Is this what you want to do?
Column 1: Column 2:
Cabbage 27 Tomato 87
Carrot 54 Potato 65
Cumcumber 14 Leek 91

I can build you a small sample if it's any help!


Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[KniteMare]

Thanks for the reply.
I spent all day yesterday developing a workaround using the page margin to make the column "Rollover.

An Overview of the issue:
The Database tracks Overtime Hours in 21 facilities linked by a WAN-LAN. This particular report shows the Difference in hours from last week compared to this week. I am currently exporting (DAO)the table to EXCEL and reorginizing the data there. (I am comfortable with VBA in the EXCEL environment.)

I want to cut out EXCEL as the middle man and have ACCESS do the work, because some machines on the network are WIN 95 and DAO (JET 4.0) is not available in that environement.

I would like the printout at the top of the page in two columns. Starting in column 1 and running highest to lowest and continuing in column two so that the reader reviews the lists top to bottom and left to right like this:

Facility Name Hours Facility Name Hours
Facility A 200 Facility G 12
Facility C 175 Facility F -43
Facility B 90 Facility E -241

If I use pagesetup to do this It runs the numbers down the left side because it does not "Hit" the bottom of the page causing it to go to the next column. To get around this I increased the bottom margin to 6" for a list of 21 facilities. This works but is not ideal.

I was thinking of this type of a solution:

Count the records, Dived that number by 2 (Round up if required) Use the result of that expression to determine how many records to include in the first column Then return the remaining records in the second column. This will allow for me to use the remainder of the page for something else.

I'm just getting started pushing Access like I do EXCEL. With EXCEL I can make it sing dance and tell jokes, With ACCESS I'll be happy if it will just roll over, I'll work on teaching it to fetch later
Yours in inACCESSable Frustration
KniteMare


Of course I can, and it will take only 900 hours of programming time to do it."
<img border=&quot;0&quot; src=&quot;

http://www.knitemare.com/Gifs/warrior.gif&quot;

>

 

[Trendsetter]

Have you considered building the 2 column report into a subreport of the main report and setting the height of the subreport to a calculated maximum.
That way the remainder of the space on the page could be utilised for additional information.

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[KniteMare]

I've done this for Forms <sub-Forms> in the past but not yet for Reports. I had not even thought of that possibility!! I currently have no idea how to proced in this direction, but I can utilize the MS <Help(less)> files associated with ACCESS and I also have my trusty albet somewhat difficult to search through, &quot;Access 97 Bible&quot; to get me started.
Thanks for the &quot;Push&quot; in a new direction.

Knitemare