Two parameters or blank 1

[teqtaq]

I am using
[Forms]![Reports]![cmb1] or [Forms]![Reports]![cmb1] is null
for my parameters.


However I ran ito dilemma where I need to have 2 parameters to consider and if there is no match - I should get blank page.
Is there way to adjust this function to have 2 parameters or nothing?

Thanks

 

[lameid]

You could use a criteria expression something like the below...

Like IIF(NZ([Forms]![Reports]![cmb1],"") = "", "*", [Forms]![Reports]![cmb1])

The above is intended to go in the criteria line in the query design view (QBE). It handles text and allows you to get everything or a specified match.

If that does not help please be more specific and include the datatypes of the fields you are using.

 

[teqtaq]

Thanks you lameid.
I am tryinig to use your method.
My problem deeply described in Parameters for multi SUB Reports post.