I have a duplicate query that selects customers that have a duplicate first name, last name and address1. Oftentimes, these duplicates originate for different store locations. I need to identify consumers from a specific store but also want to include it’s matching record that resides in another store. How do I do that?
For example I want to select the duplicate records from store 555:
John Doe, 123 Main Street, Store 555
John Doe, 123 Main Street, Store 789
If I create another query based on the dupe query and enter store 555 parameter, it will only bring up the first consumer record in the dynaset. But I need both records.