update question yes/no field

  • Thread starter Thread starter angelinarose via AccessMonster.com
  • Start date Start date
A

angelinarose via AccessMonster.com

hi all,

I have two tables one table has several fields and the other table has 4
fields. I want to be able to look into the 1st table and see if the field
"Closed" is checked yes. If it is then I want to have the 2nd table's field
called Reviewed become checked yes. Is there any way to accomplish this?
Maybe a query? I would like it to be automatically done.

thanks
 
I didn't test it but try this:

UPDATE Table2
SET Table2.Reviewed = Table1.Closed
FROM Table1, Table2
WHERE Table1.Closed = 'Yes'
 
Back
Top