Updating fields based on values from another table

[arod]

I have a table that has a Symbol column.

I have another table that has two columns OldSymbol and NewSymbol.

Can I write a query that matches up the Symbol with OldSymbol values
and then replaces them with the corresponding NewSymbol?

ie. something along the lines of:
UPDATE Table1 SET Symbol = Table2.NewSymbol WHERE
Symbol=Table2.OldSymbol
(obviously that doesn't work)

 

[Guest]

Open the query in design view and remove the criteria. Click on Symbol field
in the graphic display of the table and drag to the OldSymbol of the second
table.

In the Update To row of Symbol enter [NewSymbol] and run the query.

 

[arod]

Sweet! Thanks a lot man that worked perfectly.

Open the query in design view and remove the criteria. Click on Symbol field
in the graphic display of the table and drag to the OldSymbol of the second
table.

In the Update To row of Symbol enter [NewSymbol] and run the query.

I have a table that has a Symbol column.

I have another table that has two columns OldSymbol and NewSymbol.

Can I write a query that matches up the Symbol with OldSymbol values
and then replaces them with the corresponding NewSymbol?

ie. something along the lines of:
UPDATE Table1 SET Symbol = Table2.NewSymbol WHERE
Symbol=Table2.OldSymbol
(obviously that doesn't work)