Update Query

[Drunkenneo]

I Have two tables:

DE
--------
id PK
orig FK ref id code
Dest FK ref id code
flag



Code
-------
id PK
cod
flag


here the code tables have column flag entry as 0 or 1

Problem is if either one of orig and dest have flag entries as 1 or both have 1 i want to update the flag in DE table as 1 or else 0. Can i acheive that by using a query, Please help

 

[ct2013]

Use an update query, see more:
http://office.microsoft.com/en-gb/access-help/update-data-by-using-a-query-HA010076527.aspx