Finding Duplicates

[jason246day]

I have having trouble running my duplicate finder query. The table I am running off, Orders, contains hundreds of thousands of rows. One of the colums in this table is Customer ID, which contains a company id that signifies which of our clients this order came from.

I am wanting to find duplicate social security numbers within one customer id. The problem I am running into is the the query finds the duplicates, then filters down to the proper customer id. When this happens, a customer that has placed an order with another company shows up as a duplicate, but it really isn't.

So what I am trying to accomplish is to filter down my table to show orders from only one customer ID, and then look for the duplicated SSN's.

 

[lupins46]

If you run the Find Duplicates query wizard you can select both fields and it will give you the list you want.

 

[jason246day]

I've already tried that. It finds the duplicates on the whole table, then filters. I am wanting to filter first, then find the duplicates.

 

[PHV]

Why not running the Find Duplicates query wizard against a filtered saved query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jason246day]

PHV, how do I do that?