Query with empty criteria

[valterduarte]

Hello!

I'm sure this has been answerd before but I can't find any thread with this information:

I have a query with two criterias, wich are obtained from dialog boxes.

The queria gives me the result of Criteria A AND Criteria B.

However, sometimes I want to leave one of the criterias blank. In these cases I think the query looks for all the record with an empty field in that criteria which is not what I'm looking for.

Can anyone help me?

Thank you!

 

[ZmrAbdulla]

If you are passing criteria from a form then it will be something like..

[Forms]![myForm]![myControl] OR [Forms]![myForm]![myControl] Is Null

________________________________________________________
Zameer Abdulla
Help to find Missing people
Even a thief takes ten years to learn his trade.

 

[valterduarte]

Hello!

Thank you, but it is still not functioning.

I've placed a printscreen here:

http://upload2.postimage.org/29403/photo_hosting.html

What am I doing wrong?

 

[valterduarte]

I've been able to solve the problem with:

Like IIF([Parameter A] is Null,"*",[Parameter A])