Find and replace data in multiple tables

[Dave]

Is there a utility that will look in all tables and change Field data?

So if I have a zip code that resides in multiple tables, I want to search
all tables and find that field data.

Does such a utility exist?

thanks

 

[Rick B]

Probably not, but a simple update query would do it.

 

[Dave]

But I would need an update query for each table, correct?

The hope would be that there would be a single query that would go through
all of the tables at one time.

Thanks

 

[Guest]

Why do you have zip code data in multiple tables? This indicates a possible
database design problem.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Rick B]

How many tables do you have? Your address data should all be in one table.