Hello All,
I built and manage simple access databases for a couple of local charitable organisations. Unfortunately things don’t always stay simple, which is the situation I find myself in now.
I have a report which when run snaking ‘across then down’ works absolutely fine. When set up to snake ‘down then across’ does its own thing and seems to pay no attention to my parameter settings !
The report forms the base document of a music festival programme which lists under each different class-number and title, all the names of the competitors. Clearly some classes, of which there are about 500, have only 1 or 2 competitor names where others may have 40+.
The build, in Access 03, is a report/sub-report. Class-numbers and titles supplied by the main report and the competitor names by the sub-report set in the Detail Section. Using Page Setup I’ve set the column(s) and spacing parameters for the sub-report. It just won’t work.
As I write this, my own logic tells me that even if I can get the ‘down then across’ columns function to work, the first column will have to fill to the bottom of the page before any names will be placed in the second column. Is there a method to equalise the column lengths? Snaking ‘across then down’ gives two equal length columns which is good page layout for the programme.
I would appreciate any suggestions, to get the function to work correctly, even if I have to stick with ‘across then down’ !
Bomac.
I built and manage simple access databases for a couple of local charitable organisations. Unfortunately things don’t always stay simple, which is the situation I find myself in now.
I have a report which when run snaking ‘across then down’ works absolutely fine. When set up to snake ‘down then across’ does its own thing and seems to pay no attention to my parameter settings !
The report forms the base document of a music festival programme which lists under each different class-number and title, all the names of the competitors. Clearly some classes, of which there are about 500, have only 1 or 2 competitor names where others may have 40+.
The build, in Access 03, is a report/sub-report. Class-numbers and titles supplied by the main report and the competitor names by the sub-report set in the Detail Section. Using Page Setup I’ve set the column(s) and spacing parameters for the sub-report. It just won’t work.
As I write this, my own logic tells me that even if I can get the ‘down then across’ columns function to work, the first column will have to fill to the bottom of the page before any names will be placed in the second column. Is there a method to equalise the column lengths? Snaking ‘across then down’ gives two equal length columns which is good page layout for the programme.
I would appreciate any suggestions, to get the function to work correctly, even if I have to stick with ‘across then down’ !
Bomac.
