[RESOLVED] MS Access multiple grouping proper presentation
No help needed anymore, have created a report through code who writes to Excell, and it looks like I wanted it.
Anyone who can help me with grouping on report with proper presentation ?
I got
Code:
Group 1 = First
Group 2 = Second
Data
First 1
Second 1
Data 1
Data 2
Data 3
Second 2
Data 1
Data 2
Data 3
Second 3
Data 1
Data 2
Data 3
First 2
Second 3
Data 2
Data 4
Data 5
Second 4
Data 2
Data 4
Data 5
I want it to be shown as
Code:
Group 1 = First
Group 2 = Second
Data
First 1
Second 1
Second 2
Second 3
Data 1
Data 2
Data 3
First 2
Second 3
Second 4
Data 2
Data 4
Data 5
Can't find anything to make this work.
In db i got 2 tables
1st table got 2 fields
First Second
2nd table got 2 fields
First Data
Those are connected through First.
In 1st table there are no doubles, Key is combination of the two fields.
Hope u can understand it.