Return records where field duplicates

S

Stefan

I need to create a primary key field on a table which already has 2500 records.

Is there a way I can filter a query to only return records whose primary key
field has duplicates?


Also is there a way to return records whose character count does not equal 8
characters?
 
A

Allen Browne

There will be no records where the primary key field is duplicated. By
definition, a primary key contains no duplicates.

Perhaps you are trying to remove duplicates in a field so it can become a
primary key? If so, see:
Finding Duplicates in an imported DBF
at:
http://allenbrowne.com/xbase-04.html

To locate the records where the field name Field2 does not contain 8
characters, create a query into your table, and type this into a fresh
column in the Field row:
Len([Field2])
Then in the Criteria row, enter:
<> 8
 
Top