Identifying Duplicate entries with criteria.

  • Thread starter Thread starter vw
  • Start date Start date
V

vw

How do I write the query to identify where exact
duplicate entries have been entered for two fields, but a
third field differs.
Example of results required:
Field 1 Field 2 Field 3
apple pear orange
apple pear banana

Help with this would be much appreciated.
 
How do I write the query to identify where exact
duplicate entries have been entered for two fields, but a
third field differs.
Example of results required:
Field 1 Field 2 Field 3
apple pear orange
apple pear banana

Help with this would be much appreciated.
Click to expand...

Create a Self Join query by adding the table to the query window
*twice*. Join the two instances, field1 to field1, field2 to field2;
on the Criteria line under Table_1.Field3 (or whatever alias Access
gives you) put

<>
.[Field3]

(using your own table name of course).
 
Back
Top