Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two different fields in a table that contain duplicate records. I need
to be able to run a query that will find the duplicate records. Find
duplicates only seem to work when looking at one field. In Excel i ran an
(Exact) function to find the duplicate record between the two fields. How do
i do this in Access.

Lisa
 
Hi:

I assume you uses the "Find Duplicates Query Wizard" in Access. This lets
you match only one field.

To do more than field - open Query in Design Window - in field being matched
you will see a SQL statement in Criteria Row - you can do the same thing for
more than one field in the design window. For example you are matching on
Category field and also want to match on Manufacturer. Add Manufacturer to
the Query and in Criteria you need to type the appropriate SQL similar to
Category in syntax - just change the field name and table name as
appropriate.

Regards,

Naresh Nichani
Microsoft Access MVP
 
Back
Top