View Full Version : report with several group-headers


TjS
09-26-2007, 11:07 PM
Is it possible in a MS-Access report to place fields which are in group headers on one line?

Example:

Situation now:
First group Name; line 1: TjS
Second group Occupation; line 2: Programmer
Third group Work; line 3: programming
Third group Work; line 4: testing
Third group Work; line 5: analyse

Situation wanted:
Line 1: TjS Programmer programming
Line 2: testing
line 3: analyse

I know that it is of course possible to, in the main query, combine the fields and 'make' a new group header in which all different fields are combined to one, but in case of the third group that ain't working. I am looking for a solution (like in Crystal Reports there is an option to "underlay the following sections", something like that)

Thanks in advance for the help

TjS
10-01-2007, 03:43 AM
I have tried to solve my problem meanwhile by placing all the fields in the last group and turning the property "Suppress if duplicated" to "yes", but then (of course) some fields are not sorted, or some fields are left blank other then fields next to it...

Thus...not helping...

please if any one knows an answer i would appreciate it.....