Query Criteria Question

[shoelesscraig]

I've searched for this a thousand ways, but still can't find what I'm looking for. But, I'm sure I'm missing it (or not realizing that there is a better way to do what I want)...so I apologize ahead of time.

In a query "criteria" box, I'd like to do something like use an IIf statement, and say that: If "x" is true, then the criteria is "y", but if "x" is false, then act as if the criteria box is completely blank (return all records for that particular column). I've tried using Null, but that obviously doesn't mean what I though it did. I tried putting " " in there, but it doesn't like that either.



What am I doing wrong? I'm sure it's something basic I'm not realizing...

[CJ_London]

always helps to provide a bit of the sql to put into context. best guess at what you want would be something like

WHERE (x=true and somevalue=y ) or x=false

or slightly shorter

WHERE (x and somevalue=y ) or not x