Q1
I have a report where there are 40 check box results. I only need the totals.
I can't find a way to put the first lot(20) of field headings on the top half of the report and the next lot(the remaining 20) on the bottom half.
Report only has a total of 10 lines down, but is 2 landscape pages wide!!!
Q 2
Have a report where groupings are by category, then field 1, field 2 etc. This means that if there are repeats of cats. or field 1, 2 etc they are not displayed but in the final col. all dates relevant are displayed.
When doing a count on Categories, field 1, 2 etc I am getting a count on all lines of data in last col. where I just need count of the various categories, fields displayed, not the repeats.
I have tried going over to the ms access site, but I obviously am not using the correct terminolgy that will help me look up their examples.
I have a report where there are 40 check box results. I only need the totals.
I can't find a way to put the first lot(20) of field headings on the top half of the report and the next lot(the remaining 20) on the bottom half.
Report only has a total of 10 lines down, but is 2 landscape pages wide!!!
Q 2
Have a report where groupings are by category, then field 1, field 2 etc. This means that if there are repeats of cats. or field 1, 2 etc they are not displayed but in the final col. all dates relevant are displayed.
When doing a count on Categories, field 1, 2 etc I am getting a count on all lines of data in last col. where I just need count of the various categories, fields displayed, not the repeats.
I have tried going over to the ms access site, but I obviously am not using the correct terminolgy that will help me look up their examples.
