Group Count of Dates (No Duplicates)

  • Thread starter Thread starter NFL
  • Start date Start date
N

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
 
NFL said:
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.
Click to expand...


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
 
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
 
Thank you ... that did the trick! :-)

Duane Hookom said:
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
Click to expand...
 
Back
Top