too many fields in Report headings + Count problems

[soojosie]

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 of field headings on the top half of the report and the next lot 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 repeated 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.
I have tried going over the the ms access site, but I obviously am not using the correct terminolgy, that will help me look up their examples.

 

[GingerR]

1) make two subreports, the first with the first group of headings, the second with the second group of headings. put them into a blank report in the detail section. you can set each subreport CanShrink and CanGrow properties to yes. problem is if you have more rows that will fit nicely on the page.

2)i dont understand "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. please explain better and put in example of what you mean. thanks.

g

 

[soojosie]

Hej GingerR,
Thanks for your help, have not used a sub report before but am in the process of finding out about it.
Q2
My report has several groupings Field1, Field2 etc. I am trying to get a total of the various groups. Example: need a total for New or Chair. All my totals = 5.

New Chair Green
Blue
Table Green
Blue
Old Chair Grey

 

[GingerR]

do you have a heading for Field1, Field2 etc? you can make a heading for each, create a text box in that heading, and makes it's control source be:

=Count(*)

 

[soojosie]

Ginger, that is brilliant thanks so much.
Josie)