gojets1721
Registered User.
- Local time
- Today, 15:18
- Joined
- Jun 11, 2019
- Messages
- 430
I've attached an example database with a similar table to what I'm working with. I'm looking to create a query that removes all duplicate customer entries based upon whichever entry has the lowest number in the DocumentAge field. For example, for the Emily Smith customer, the query would only include the entry where the DocumentAge is 12 and not include the entries with 344 and 91.
Any ideas?
Any ideas?