Update Query with two tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sorry for the newbie question.

I have two tables. The first one has several fields, two of which are: STCC,
STCC Definition (currently blank, I want to populate this field). The second
table is an all-encompasssing database with all STCC's and their definitions.

When STCC fields matches in both tables, how do I extract the definition
from the reference table and populate the corresponding empty field in the
master table?
 
Sorry for the newbie question.

I have two tables. The first one has several fields, two of which are: STCC,
STCC Definition (currently blank, I want to populate this field). The second
table is an all-encompasssing database with all STCC's and their definitions.

When STCC fields matches in both tables, how do I extract the definition
from the reference table and populate the corresponding empty field in the
master table?
Click to expand...

Create a new Query joining the two tables by STCC.

Change it to an Update query.

In the Update To line under [STCC Definition] type

[tablename].[STCC Definition]

using the second table name. The brackets are essential (otherwise it
will update all of the definitions to the text string "tablename.STCC
Definition", which you don't want!)

John W. Vinson[MVP]
 
Back
Top