Update Query with a counter

[hockeyman9474]

I think using the * is perfect. If the Street Name 123 Anywhere Street and I use *Anywhere Street then the code will compare to any data in the table that ends in Anywhere Street, no matter what comes before it. The only downside is if the user types Anywhere Street compared to St. correct?

Now that I understand what is going on let me code and see if i get it to work. I'll let you know. Great Lesson and thank you.

[hockeyman9474]

Success. I accomplished my goal for the day and learned a whole lot at the same time. I used to work in Access and now I work in SQL, but never the two two did I mix until today. I don't know your real name but mine is Adam and I sincerely thank you for your time and patience.