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)?
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)?
Maybe a CROSSTAB query is what you want.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Okay, maybe a multi-column report with a forced break (page break) after each group. https://www.accessforums.net/reports...umn-34808.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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.
Then multi-column without forced page break after each group. Snake the column down then right. http://ezinearticles.com/?Multi-Colu...007&id=1916762
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
So, It was a simple fix.
just change the print page settings.
thanks for your input