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