Update Queries and Yes/ No fields

[harrysdad]

I have an update query where I want the query to update a field in table 1 with a value from a field in table 2, and another field in table 1 with a text value, where another value in another field in table 2 satisfies a certain criteria - in this case it is a yes/ no field.

so I have under update to:[table2].[field_name]
and update to "string"
where criteria ([table2].[yes/no_field])= value

The query will not work. I'm not sure if this is because I am entering the wrong things in the criteria for a yes/ no and it is not recognised, although I get no error message.

I have tried = false/ true, yes/no, -1 / 0 etc and got nowhere.

Any help will be greatly appreciated.

 

[BNPMike]

Can you go into SQL view and cut the SQL, and paste it here?

When you say it doesn't work, what actually happens?