I have a problem with a report I am doing where I need to get complete totals for codes but I am getting them separated by my groups. I have them grouped by Activity Code, Reference Code and then Result code. I would like the report to turn out like this -
Activity Codes
1 - (count)
2 - (count)
3 - (count)etc.
Reference Codes
1A - (count)
1B - (count)etc.
Result Codes
1Aa - (count)
1Ab - (count)
1Ac - (count)etc.
As of now it is turning out that the codes are showing up nested inside each other and not separated like I have shown above. I know this is the way it is supposed to work but my question is how can I get them to show up like I have demonstrated above. Hope this makes sense.
Thanks, Joe
Activity Codes
1 - (count)
2 - (count)
3 - (count)etc.
Reference Codes
1A - (count)
1B - (count)etc.
Result Codes
1Aa - (count)
1Ab - (count)
1Ac - (count)etc.
As of now it is turning out that the codes are showing up nested inside each other and not separated like I have shown above. I know this is the way it is supposed to work but my question is how can I get them to show up like I have demonstrated above. Hope this makes sense.
Thanks, Joe