Multiple Fields with Grouping & Multiple Columns(Access97)

[bondm007]

I have a report the has 3 grouped headers and I would like to have multiple columns in the detail section for the 4th, 5th and 6th fields. Is this possible? I have already tried the multiple columns in page setup. I got multiple columns for everything (not just the detail section). Thanks

What I got with multiple columns on:

Field1 Field1
Field2 Field2
Field3 Field3
Field4 Field5 Field6 Field4 Field5 Field6
...

What I have right now:

Field1
Field2
Field3
Field4 Field5 Field6
Field4 Field5 Field6
...

What I would like to have:

Field1
Field2
Field3
Field4 Field5 Field6 Field4 Field5 Field6
Field4 Field5 Field6 Field4 Field5 Field6
...

 

[67peshawar294]

Hi 007,
In the sorting and grouping for the report in design view set the order for the field1 field2 field 3. in the "group properties select: yes,yes,eachvalue,1,whole group. Your page setup should be set to 2 columns, down and across.
Jim