emjay Posted October 6, 2007 Share Posted October 6, 2007 This may be an easy one but I'm stumped. I have a db with the fields firstname, lastname and other data. I'm importing records from an excel spreadsheet. I get multiple firstname/lastname combinations. I'd like to get a unique list of all the the firstname/lastnames without the multiple repeats. I can't figure out how to do this. Much obliged for any help. Cheers, MJ Link to comment Share on other sites More sharing options...
bcooney Posted October 8, 2007 Share Posted October 8, 2007 Hate to discourage you, but finding duplicates after import is not easy. The crux of the matter is "What is a Duplicate?" If you can come up with a DupCheck calc field, then in Find mode you can search for records that have the same data in DupCheck by using the "!" symbol (the DupCheck field must be set to be Unique). Check out John Mark Osborne's tip: Isolating Duplicates I think you'll end up with a found set of possible duplicates that you'll let the user view and delete the records that they've decided are the real duplicates. Then, you'll have to help them with the appropriate warnings when they delete (for example, what if they are deleting a record that has children?). Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6179 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now