Post Author: grandvizier
CA Forum: General
or both
I've got data in the Res table (ID, time, ...) and then a Group table thats linked to the Res ID (and there are other tables linked in the group too) - an example of the layout I'm looking for in the report is something like:
ID
GroupName
Time
A/D
Agent
23
Smiths
1245
A
Tre
jones
D
Ads
A
26
Tom
945
D
Tre
Keiv
A
instead of what I currently have which is like this:
ID
GroupName
Time
A/D
Agent
23
Smiths
1245
A
Tre
23
jones
1245
D
Tre
23
Ads
1245
A
Tre
26
Tom
945
D
Tre
26
Keiv
945
A
Tre