Extract Duplicate Key Field but have a 2nd Fieled different

[DaveT99]

I have a single table called SPARES


The table has 3 fields, Stock_No, Store_Id, Description
In this data set there are duplicate Stock_Nos because

• Same stock_no is held in different storage locations on site (Stock_no is linked to its makers part number)
• But also there are true duplicates, same stock No in same location

In some cases the part description has been created differently for the same stock_no

I would like to extract all duplicate stock Nos where the descriptions are different

I made a query to extract the duplicate stock Nos and another to show where the same stock no was located in the same store location (True duplicate)

I then tried creating a 3rd query based on the duplicate stock no query, but am struggling to extract the records with duplicate Stock_Nos but with different populated descriptions
Can anyone help?
Maybe it be done in a single query by you clever people?

[DaveT99]

Hi VIP
Thanks for your reply, BUT I am Not sure why but I am not seeing your reply when I am logged into my account, only when I hyper linke from the e mail and then I am not logged in, and its doesnt accept my log in details ...........computers grrrr or is it me
Anyway tried your solution but it creates a extra row in my little demo database BUT will try in main application in the next 1 hours. Many thanks an interesting solution
Dave