Easy Query Criteria Question... 1

[danomaniac]

Hey gang,
I'm having trouble with a query statement.

Expr2: IIf([forms]![frmName]![checkbox1]=True,[EndTime] Is Null,[EndTime] Is Null Or <[forms]![frmName]![txtEndTime])

If the checkbox is checked, the query works and returns only records with no EndTime, but if the checkbox is not checked, I get no records at all. I want all records that are either null or less than txtEndTime.

I know I'm close, but can't seem to close the deal. Any help would be appreciated.

Thanks.
Dan

&quot;It's more like it is now, than it ever has been.&quot;

 

[SteveR77]

Dan,

Try this -


Expr2: IIf([forms]![frmName]![checkbox1]=True,[EndTime] Is Null,([EndTime] Is Null Or [EndTime]<[forms]![frmName]![txtEndTime]))



Hope this helps,

Steve

 

[danomaniac]

Steve.

Awesome! I knew I was close. Thanks very much - nothing worse than banging your head on the monitor because you can't think of something. Worked perfectly. Thanks again.

Dan.

PS..Have a star!

&quot;It's more like it is now, than it ever has been.&quot;