updating a field that uses the Yes/No Data Type

[badger8]

I have a list of accounts that I would like to mark HTML_Unable. I have a field called Html_Unable that uses a yes/no data type.

How would I create an UPDATE SQL statement that would allow me to find all contacts within a specific account and set their Html_Unble value to yes?

Any direction in this would be great?

Thanks
Ray

 

[LittleSmudge]

Use the KeyWord "TRUE"



As in:-

"UPDATE tblCopyOver SET tblCopyOver.HTML_Unable = True
WHERE (((tblCopyOver.Field1) = 'ABC'));"

( Change the WHERE Clause to whatever you need to "find all contacts within a specific account" )

'ope-that-'elps

G LS