Hi All,
I have a database that I inherited that has street address backwards and with spaces.
Example1. E SEASIDE ST 64 1/2
Example2. MAIN ST 154
Example3. BOSTON POST RD 25
There are about 50,000 records and I am able to create a function to take out the whole numeric number like 62 or 154 but have issues with street names and streets that are like E for east W for west. I am not the greatest at Access and I am still learning so any help or insight would be great.