I have a list of thousands of names, account #s, addresses and another field denoting the type of address. basically what it looks like is this:
123 John Doe Main St. 00
456 Jane Smith Elm St. 00
456 Jane Smith Elm St. 30
789 Jim James Oak St 30
901 Mary Brown First St 00
What I want to do is extract all the accounts but when it runs into a duplicate account, only extract the one with a 30 and leave the other. In this list of thousands there may only be a couple dozen duplicates but since this list is refreshed and overwritten everyday by an external application I can’t delete the duplicates once leaving the one I want to keep. In the above example I want to end up with 4 records.
Being brain dead at this point in the day it just occured to me that Access would do better for this problem. What do you think? The problem is everyone at work has Excel and only a few have Access. Once I get this working I want to hand it off to someone.