How to find duplicate in 2 fields

[DaveT99]

I have a table, i will assume 4 fields


- stock no the key field
- part description
- p/n
- store location (this is an actual store and not a bin location)

its easy to create a duplicate query to find duplicate p/ns

but how to find duplicate p/ns held in the same store location

regards
dave

[Welshgasman]

Group by part number and location having count >1 ?