>Hi All,
>Must I be a premier member to attach a picture? I didn't find it in updating account. Anyway, that's not my question.
>I am trying to figure out how to seek on a database to find the unwanted duplicate fields. How would one say:
>" SEEK on namecode FOR " namecode occurs twice or more in this database" ??
>I know this should be very simple.
>thanks for any help!
You can do this with SQL Select:
SELECT FieldName, COUNT(*) ;
FROM TableName ;
GROUP BY FieldName ;
HAVING COUNT(*) > 1
Just fill in TableName and FieldName with the appropriate values.
Chris McCandless
Red Sky Software