Hello, I'm fairly new to Access, I was hired at a magazine as a publishing assistant about 4 months ago and our subscriber database is all in Microsoft Access 2007, BUT in Access 2000 format, if that helps at all.
I also have to clean data from a local government agency to create a list of people to send free magazines to. This is where I thought that there has to be a faster and more efficient way of "cleaning names" as we call it.
I have six fields: FirstName, LastName, Address, City, State, Zip.
My main objective is to make sure that no address receives more than one magazine, therefore I need to remove all duplicate addresses. I have already utilized Find/Replace to clean up things like "St" and "Street," etc. to more easily remove duplicates, but now I want to go further.
I want to be able to find all addresses that are similar in the beginning so I can easily find messy data and remove it. For example, I want to be able to run a query of some sort that would show these addresses due to their similarity:
1035 Fairview Dr
1035 Fair View Dr
1035 Fair View Apt 5
or
127 Sprucewood Dr Apt #4
127 Sprucewood Dr Apt 4
If nothing else, I would like to be able to find all addresses that have the same first 3-5 numbers/characters.
I apologize in advance for my lack of Access knowledge, but I really do appreciate any advice available.
I also have to clean data from a local government agency to create a list of people to send free magazines to. This is where I thought that there has to be a faster and more efficient way of "cleaning names" as we call it.
I have six fields: FirstName, LastName, Address, City, State, Zip.
My main objective is to make sure that no address receives more than one magazine, therefore I need to remove all duplicate addresses. I have already utilized Find/Replace to clean up things like "St" and "Street," etc. to more easily remove duplicates, but now I want to go further.
I want to be able to find all addresses that are similar in the beginning so I can easily find messy data and remove it. For example, I want to be able to run a query of some sort that would show these addresses due to their similarity:
1035 Fairview Dr
1035 Fair View Dr
1035 Fair View Apt 5
or
127 Sprucewood Dr Apt #4
127 Sprucewood Dr Apt 4
If nothing else, I would like to be able to find all addresses that have the same first 3-5 numbers/characters.
I apologize in advance for my lack of Access knowledge, but I really do appreciate any advice available.