need distinct count 1

[Lhuffst]

I have a report that has 4 tables. The group level counts the number of records in that group fine. Now the user needs a distinct count for the group.
The group is on MeterID which allows duplicates because of reissue dates. I need a distinct count of the meter id's and showing the details. This is something simular to what I need.

Meter 1234 Count for 1234 = 2
Permit 1 Issued 7/7/11
Permit 2 Issued 7/11/11
[blue]
Total count for meter = 1 [/blue]

I have everything but the total count line.

 

[Lilliabeth]

put a text box in Group header... name it txtCountOfGroups
Set control source to =1, and the Running Sum property to Over all

In report footer, put a text box with control source of =txtCountOfGroups

--Lilliabeth

 

[Lhuffst]

works like a charm Thanks