Group Count of Dates (No Duplicates)

[NFL]

I have a report grouped by day/month/year. The date field IS only placed on
the group header and not in the details. The details may show many
occurances and I would like to count the days once.

Thank you

 

[Marshall Barton]

I have a report grouped by day/month/year. The date field IS only placed on
the group header and not in the details. The details may show many
occurances and I would like to count the days once.

Add a text box (named textRunCount) to the group header or
footer) section, Set it's control source expression to =1
and RunningSum to Over All. Then a report footer text box
can display the total by using the expression =textRunCount

 

[Duane Hookom]

Apparently you want to count group headers. If this is the case, add a couple
text boxes:

Section: Group Header
Name: txtRunCount
Control Source: =1
Running Sum: Over All
Visible: No

Section: Report Footer
Control Source: =txtRunCount

 

[NFL]

Thank you ... that did the trick!

Apparently you want to count group headers. If this is the case, add a couple
text boxes:

Section: Group Header
Name: txtRunCount
Control Source: =1
Running Sum: Over All
Visible: No

Section: Report Footer
Control Source: =txtRunCount