Update query

R

Radhika

I have the following SQL statement for an update query:

UPDATE tbl_TEPRecords SET tbl_TEPRecords.[VP Other:Custom] = True,
tbl_TEPRecords.[VP Other:Glue of valve/hinge] = True
WHERE (((tbl_TEPRecords.[VP Other:Extra Increased Resistance])=True)) OR
(((tbl_TEPRecords.[VP Other: Extra Extra Increased Resistance])=True)) OR
(((tbl_TEPRecords.[VP Other:Increased Resistance])=True) AND
((tbl_TEPRecords.[VP Type])="InHealth Duckbill" Or (tbl_TEPRecords.[VP
Type])="InHealth Indwelling Standard w/ Enlarged Flange" Or
(tbl_TEPRecords.[VP Type])="Bivona Ultra low" Or (tbl_TEPRecords.[VP
Type])="Bivona Duckbill" Or (tbl_TEPRecords.[VP Type])="Dummy Prosthesis" Or
(tbl_TEPRecords.[VP Type])="Provox Active Valve" Or (tbl_TEPRecords.[VP
Type])="Provox" Or (tbl_TEPRecords.[VP Type])="Provox NID" Or
(tbl_TEPRecords.[VP Type])="Provox 2" Or (tbl_TEPRecords.[VP Type])="InHealth
Advantage")) OR (((tbl_TEPRecords.[VP Other:Glue of valve/hinge])=True));

I need to add to this one more criterion:
If none of these condition are met, the field 'VP OtherGlue on valve/hinge
is False (or not checked)

How do I insert this into the SQL?

Thank you
Radhika
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top