Count "Visible" Date field

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
 
D

Duane Hookom

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
 
Top