How to make duplicate fields to be counted as one?

  • Thread starter Thread starter Julia82
  • Start date Start date
J

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!
 
Julia82 said:
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?
Click to expand...


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
 
Back
Top