Afternoon, As a 1-time task I have imported an excel file(2500recs) into Access. How can I easily find duplicate keys(not primary Key) using a query, vba or a recordset. The key will be finally indexed. Thanks in advance.
Afternoon (still)
Please disregard my previous request. I found the answer in a forum of 15 years ago AND it works, "Find Duplicate in query wizard. Sorry again
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.