Update Query...I think....

[Scott D]

I want to use an Update query in Access to do the following:

I have a database that has a column OppAction with text values for
example Opportunity ID. This was an old database and I am now
programming in VB.Net and need to make some changes.

I need to be able to check the column OppAction for the string
"Opportunity ID" and if it is found make a Yes/No column OppID equal
to Yes. This seems very simple and straight foward but I cannot seem
to get the criteria in the update query formatted correctly. I have
many of these to check.

Extra Info:

The original database had a frontend ASP page that when a radio button
was checked the value of the button was passed to the column. In this
case the value was Opportunity ID. This was done instead of creating
bit columns and passing a 1 for checked and a 0 for unchecked.

Thank you in advance for help.

 

[MGFoster]

I want to use an Update query in Access to do the following:

I have a database that has a column OppAction with text values for
example Opportunity ID. This was an old database and I am now
programming in VB.Net and need to make some changes.

I need to be able to check the column OppAction for the string
"Opportunity ID" and if it is found make a Yes/No column OppID equal
to Yes. This seems very simple and straight foward but I cannot seem
to get the criteria in the update query formatted correctly. I have
many of these to check.

UPDATE TableName
SET OppID = True
WHERE OppAction = "Opportunity ID"