I am trying to do some summarizing of data in a report and having a problem using the Count function. Some sample data:
Section Class App# Doc# Entry#
1 1 1 1 1
1 1 1 2 2
1 2 1 1 3
1 2 2 3 4
1 3 2 3 5
1 3 3 1 6
1 1 3 2 7
The report sorts by section and by class then by Doc# and by App#
The report has parts: Report, Page, Section, Class.
In the Class part, I can get a Count of items in class by counting any of the three (App, Doc, Entry) but I cannot figure out how to get a count on the unique number of items in App# and Doc# for class. Everything that I try gives me the same number as I get for just regular Count. Can someone give me some help?
Thanks,
RayJay
Section Class App# Doc# Entry#
1 1 1 1 1
1 1 1 2 2
1 2 1 1 3
1 2 2 3 4
1 3 2 3 5
1 3 3 1 6
1 1 3 2 7
The report sorts by section and by class then by Doc# and by App#
The report has parts: Report, Page, Section, Class.
In the Class part, I can get a Count of items in class by counting any of the three (App, Doc, Entry) but I cannot figure out how to get a count on the unique number of items in App# and Doc# for class. Everything that I try gives me the same number as I get for just regular Count. Can someone give me some help?
Thanks,
RayJay
