Thanks,

I got the query working with 2 variables, but im getting a syntax error
(missing operator) when i try to add a third, ive got 4 total to incoprorate.

Heres what ive got so far:

SELECT *
FROM bncforms_table
WHERE Iif (Forms![FormRpt]![chkEdi] = True and Forms![FormRpt]![chkWeather]
= true and Forms![FormRpt][chkNoEnter] = true, ([bncforms_table]![edi] = true
and bncforms_table![Weather Ntc] = true and bncforms_table![No Enter] =
true), Iif (Forms![FormRpt]![chkEdi] = True, [bncforms_table]![edi] = true,
iif (Forms![FormRpt]![chkWeather] = true, bncforms_table![Weather Ntc] =
true, iif (Forms![FormRpt][chkNoEnter] = true, bncforms_table![No Enter] =
true, "*"))))

"KARL DEWEY" wrote:

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.