I used the wizard to create a find duplicates query. I know for a fact that 15 records are duplicates. I'm getting over 300 records. When I dumped the data into Excel and did a pivot table to count the number of records by account number only 15 had a total count of 2. All others only had 1. Why are the ones with no duplicates showing? I just want to see the 15. Any ideas? TIA
Find duplicates query
- Thread starter Angel69
- Start date
Actually, I advise 3 things:
1. SQL of your query.
2. Plain english description of what a 'duplicate' is to you.
3. Example data that shows both 'duplicates' and 'distincts'
I've found the people's definitions of the terms 'Duplicate' and 'Unique' hardly ever match what the dictionary's definitions of them.
1. SQL of your query.
2. Plain english description of what a 'duplicate' is to you.
3. Example data that shows both 'duplicates' and 'distincts'
I've found the people's definitions of the terms 'Duplicate' and 'Unique' hardly ever match what the dictionary's definitions of them.
