Iff Statement

[JRCharlie]

Hi all
I have a query with the following columns Fname, Laname, Adress, Orderdate, ConfirmeDate, Stock.
The ConfirmDate has a Date Value, Stock is a yes/no .
I would like to display all orders where ConfirmDate is null or If ConfirmDate is not null the Stock must be Checked.
Can some one help writing this Iff Statement.
Thanks in advance.

[June7]

Try:

SELECT * FROM tablename WHERE ConfirmDate Is Null OR Stock=True;

[JRCharlie]

Thanks June 7 for your quick reply.
Your tip put me in the right direction but what I really wanted was:
SELECT * FROM tablename WHERE ConfirmDate Is Null Or ConfirmDate Is Not Null And Stock=True;

[June7]

Probably need grouping parens:

SELECT * FROM tablename WHERE ConfirmDate Is Null Or (ConfirmDate Is Not Null And Stock=True);