Finding the Number of duplicates

[Addam]

Hi Everyone!

PROBLEM:

I have a database that has several duplicate names of equipment.

GOAL:

I would like to create a calculation field that tracks the number of duplicates in a FOUND SET.

HISTORY:

I've tried using: Count(Num of Equipment::Equipment Name) and this works, accept it gives me the Total duplicates in the ENTIRE database AND the wording is not exact.

example: "Incubator" & "Incubator light" are included in the calculation above.

I need to get the total number in the current found set using the "EXACT" spelling as is.

Any suggestions!?

Thanks!

[Ugo DI LUCA]

Hi,

Well, you need to index each value of the fields using a calculation.

c_indexfield = Substitute(field, " ", "