Finding Duplicates in a Table

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

Guest

Hi,

I am trying to build a query to find multiple times a table has multiples of
if two different fields. Let me explain further with an example:

We have a table where our Purchase Orders (PO) are tracked and it has the PO
# and a Line # as its primary keys. In this table we put in the Product # of
what is going to be purchased on this PO Line. Now the problem, We have had
people who put in the same product # more than once on the same PO.

So:
PO# 123 could have part # ABC on it more than once. So line 1 could be
Product# ABC and Line # 2 of the PO could also be Product# ABC. We are not
sure why our people have done this but we have put a stop to it. But I need
to find a way to go in and find these PO's with parts that show up more than
once. I am new to ACCESS and SQL but need to find these PO's so we can
change these PO's as it is causing problems in our ACCESS reports as the
reports are built off of the PO's and it is causing duplication of data when
these PO's are a part of the query.

Basically what I think I need is a query to find where the PO# and Product#
appear more than once like PO# 123 and Product# ABC show up more than once.

ANY HELP WOULD BE GREATLY APPRICIATED!!! AS ALWAYS, THANKS IN ADVANCE!!!!!!

Chip
 
Chip

Start with the table. Use the <Query> button from the tool bar. Select the
"Duplicate..." query wizard.
 
Back
Top