How to make duplicate fields to be counted as one?

[Julia82]

Hello,
I have a form with multiple textboxes. The text are linked to a table with
values. In this table I have fields with duplicate values. At the bottom of
the report I have a total. I want to know if it's possible somehow to count
the duplicate fields as one. For example

ID
1 Julia
2 Julia
3 Julia
4 Pamela

The result must be 2 records, because 3 of them are the same. How to do that
in a report?

Thanks!

 

[Marshall Barton]

I have a form with multiple textboxes. The text are linked to a table with
values. In this table I have fields with duplicate values. At the bottom of
the report I have a total. I want to know if it's possible somehow to count
the duplicate fields as one. For example

ID
1 Julia
2 Julia
3 Julia
4 Pamela

The result must be 2 records, because 3 of them are the same. How to do that
in a report?

The usual approach to this kind of thing is to have a group
on the name field with header and/or footer section. Then
add a text box (named txtGrpCount) with control source set
to =1 and RunningSum set to Over All. The header/footer
section does not need to be visible if you don't have any
other use for it.

Then the report footer text ox can display the count of
unique names by using the expression =txtGrpCount