Count "Visible" Date field

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

Is there a way to count only the visible records on a
report? My report hides duplicate values for some
fields. The total is including all records, even the
duplicates.

Thanks,
Mary
 
You could create a group header on the field that you are "hiding". Add a
text box to the group header section:
Name: txtCountIt
Control Source: =1
Running Sum: Over All
Add a control in the report footer:
Control Source: =txtCountIt
 
Back
Top