Field Comparison Module

K

Ken

Hi, I hope you are doing well.

Does anyone have a function (already coded) I can beg, borrow or steal that
will search a table for repeat fields? For instance, I'd like to be able to
search a table for repeat names in the name field and then build a table with
only one record for each entry in the first table. The repeated name record
would only appear in the new table once. In event the name is not repeated,
I'd still put it in the new table.

I hope this is self explanatory. Thanks in advance.

KenP
 
A

Albert D. Kallal

Actually, you don't need any code at all to do this.

simply crate the new table, and set a index on the field (to not allow
duplicates). Now, just run a append query...and duplicates will NOT be
copied....

Simple..and no code needed.....
 
Top