Query problem

[PascalZ]

I created a report with an underlying query. Additionally I created a form that is called when starting the report to enter the report criteria.
In form there are 5 criteria you can use.
I would like the query to return all entries when selection criteria is left blank. I used the "Is Null" statement for that. Hoever for some reason I'm not able to make a selection on one criteria and leave all others blank. In that case the query has a zero result.

Any ideas?

Best regards,

Pascal.

 

[Parra]

I think this could help you. There is a recent post that asks for what you want and this is how the guy resolved his problem.

In the criteria of the query add:
[Enter Data] OR [Enter Data] IS NULL

So if a user types something into "[Enter Data]" the query returns the data that matches that, if it is blank it returns everything.

Hope this helps