If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Boolean expressions in the where statement
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. |
Thread Tools | |
Display Modes | |
|
|