If Content in [FieldA] in Dataset No 10 is "Y", write "XY" in [FieldB] in Dataset No 1 to 9

[EPSfreak]

Hi,


I am looking for a solution for an access query.

I have a query with the result, where content of [FieldA] in Dataset no 10 is "Yes".

If this is the case, [FieldB] in Dataset no 1 to 9 has to be changed from "No" to "Yes".

Is anyone able to help me to design the correct query.

Thans and regards

[CJ_London]

Something like

UPDATE myTable
SET FieldB=true
WHERE FieldA=true