Distinct Count on a Report

N

ncm

I have a report that summarizes interactions with kids in a group home
setting. The report is sorted by Kids name, staff name. It identifies each
interaction with the kids. There will be mulitple interactions on each day.
The report is run for 1 month. I need to be able to count how many days
there was an interaction. If I do a count it gives me a count of all the
interactions. There may be 10 interactions on March 3 and 10 on March 4.
Count gives me 20 and it should be 2
 
E

Evi

See if this works. Put a text box in the section that has the interactions.
Use Properties on the Other tab to set its name to txtCount
On the Data tab set Running Sum to Over Group.
Type
=1
into the box

In the place where you want the results, put a text box and type
=[txtCount]

Evi
 
Top