I have approximately 100 Access databases (one for each cost center). Each
cost center has their own folder on a corporate drive. There are 3 other
files (Excel) besides the database in each folder. I have a macro that will
cycle through all of the folders and replace any of the 3 Excel files in each
folder.

I now need to update 2 fields ("Office", "CostCenter") in a single table.
This table only has the 2 fields and each field has a text string of "4.0".
I need to update each field with "5.0".

I'm trying to create a sql statement that will update /replace each field
with "5.0"

The database name is "MyDatabase". The table name is "Version". The field
names are "Office" and "CostCenter".

Any help getting started would be greatly appreciated. Thanks.......
--
JT