Update Query Criteria

[isoman53]

I need to set a criteria for an update query from [Location] field in table1 to table2 so that it updates if:
[table2].[Location]="Lab" and [table1].[Location]="Lost"


Tables are joined in query.

Field:Location
Table: table1
Update to:[table2].[Location]
Criteria:

I can't seem to get the statement right to make this happen. Can someone help?

 

[ksaab]

I may be misunderstanding.

You want to update Table1.Location to Table2.Location if Table2.Location = Lab? But only where Table1.Location = Lost?

Is that correct? Also, how are your tables joined?

 

[isoman53]

I may be misunderstanding.

You want to update Table1.Location to Table2.Location if Table2.Location = Lab? But only where Table1.Location = Lost?

Is that correct? Also, how are your tables joined?

They are joined one-to-one with Gage ID field. I actually did find one way that seems to work.

Column 1:
Field: Location
Tabls: Table2
Update to: "lost"
Criteria: "lab"

Column 2:
Field: Location
Tabls: Table1
Update to:
Criteria: "lost"

Is there a better way to do this?