Changing multiple records in a field

[Guest]

Greetings all. I have two tables each containing a field in reference to the
same information. I imported most of the information from two separate
spread sheets. The problem is that on the first spread sheet the colulmn
corresponding to my field listed the data in an abbriviated form of the same
data on the second spreadsheet. Is there a way to open one of the tables and
do a "change all" so that the records for that field match on both tables,
rather than manually change all one by one? There are about 500 records that
have to be changed. Thanks for any help.

Greg Snidow

 

[Guest]

Assuming consistent data entry, it is possible to update the relevant records
by using an update query. However, you will have to run the query each time
changing replace parameter and replace by parameter for each set of records
you want to update.

 

[Guest]

You can do it with one pass of an update query by building an update table
like -
Table1Field Table2Field
ABC All Better Co
XYZ Zandar Widget

Put both tables in your query but do not join. In the column to be updated
in the Update field put [Table2Field] and in the criteria put [Table1Field].

Always back a backup copy of the table before doing the update!