Boolean expressions in the where statement
Try this --
SELECT *
FROM Table
WHERE IIF(chkA = True AND chkB = True, Achk, IIF(chkA = True, Achk,
IIF(chkB = True, Bchk))) OR IIF(chkA = True AND chkB = True, Bchk, IIF(chkA
= True, Achk, IIF(chkB = True, Bchk)));
First part - if A & B true A, then check for singular true. Second part -
if A & B true B, then check for singular true.
--
Build a little, test a little.
"Paul Washburn" wrote:
Im trying to build a form with multiple check boxes that each apply a filter
to the records displayed. I need for the user to be able to select any
combination of the checkboxes and have the resulting records filtered
accordingly.
I was thinking something along the lines of a "select" or statement or an
if...else loop, but unfortunately im fairly new with sql am having trouble
with the syntax, assuming its even possible.
Something along the linse of:
Select * from Table Where
If (chkA = true) then chkA
Else (chkB = true) then chkB
else (chkA = true) and (chkB = true) then chkA and chkB
else *;
Any help would be greatly appreciated.
|