LisaRae007
New member
- Local time
- Today, 12:13
- Joined
- May 5, 2003
- Messages
- 8
Thanks for reading and considering my question!
I have two tables:
ValidAddresses
Restaurants
The valid address table contains precise location information, with a separate field for each component of the address: number, streetname, streetsuf, city, zipcode and parcelnumber. Because I am working towards using this data for a mapping application, the most important field here is the parcel number.
So, I have a table of Restaurants that I need to match to the ValidAddress table so that I can give each restaurant a parcel number (for the mapping..long story). The problem here is that the addresses in the Restaurant table are all in one field (data came from another source). I would like to avoid the tedious process of trying to parse out the address info.
Therefore the problem: I am trying to write an update query that will use wildcards to compare the restaurant address to the table of correct addresses and then if it can find something that matches, it will update the blank parcel field in the restaurant table, resulting in a restaurant table with parcel locations.
I am not good at designing recursion, but I am concluding that I need to basically set up a recordset to loop through and check each restaurant to see if there is a match and if so, put the corresponding parcel number into the restaurant table.
I have two tables:
ValidAddresses
Restaurants
The valid address table contains precise location information, with a separate field for each component of the address: number, streetname, streetsuf, city, zipcode and parcelnumber. Because I am working towards using this data for a mapping application, the most important field here is the parcel number.
So, I have a table of Restaurants that I need to match to the ValidAddress table so that I can give each restaurant a parcel number (for the mapping..long story). The problem here is that the addresses in the Restaurant table are all in one field (data came from another source). I would like to avoid the tedious process of trying to parse out the address info.
Therefore the problem: I am trying to write an update query that will use wildcards to compare the restaurant address to the table of correct addresses and then if it can find something that matches, it will update the blank parcel field in the restaurant table, resulting in a restaurant table with parcel locations.
I am not good at designing recursion, but I am concluding that I need to basically set up a recordset to loop through and check each restaurant to see if there is a match and if so, put the corresponding parcel number into the restaurant table.
