Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouping / Count Problem

Status
Not open for further replies.

DVFS

Programmer
Sep 21, 2000
44
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top