Show Query Results in 3 Columns

[WickidWe]

Hi



I have a report Based on a query and it is all grouped by Function.
All the Results together Are only 5cm Wide
is there a way to show them in 3 Columns Across and then go to a new row / line / block (whatever it is called)?

[June7]

Maybe a CROSSTAB query is what you want.

[WickidWe]

I dont think that is it.
the outcome is layed out exactly how I need except it Doesnt use up the page as in the pic

[June7]

Okay, maybe a multi-column report with a forced break (page break) after each group. https://www.accessforums.net/reports...umn-34808.html

[WickidWe]

The Problem with this method is that I dont need a column for each group
I need it only to go to a new column once it gets to the bottom of one page as it will be printed on and must all fit on a single A3 Page.

[June7]

Then multi-column without forced page break after each group. Snake the column down then right. http://ezinearticles.com/?Multi-Colu...007&id=1916762

[WickidWe]

So, It was a simple fix.

just change the print page settings.

thanks for your input