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
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