Access 2003 indexing records

[Guest]

Wondering if it is possible to find duplicates between two columns of info.
For instance ABC Company in one and I want to know if ABC Company is in the
other column. Can this be done via indexing, or some other method? If so,
how?

 

[John Vinson]

Wondering if it is possible to find duplicates between two columns of info.
For instance ABC Company in one and I want to know if ABC Company is in the
other column. Can this be done via indexing, or some other method? If so,
how?

A Self Join query can do this, if I undestand correctly. Create a new
Query by adding the table to the query grid *twice*. Drag the first
column from the first instance to the other column in the second
instance; select whatever fields you want to see.


John W. Vinson[MVP]