Handling null value in parameter query

[Nabeel Ismail]

I have to give a three paramters queries. But i have to handle null responses also in such a way that in one parameter or two parameters i don't want to enter value and the result should bring all possible values with the parameters I entered

Like customer, status and order number in different fields

when i don't enter order number the result should bring all values in status and customer

 

[Newman]

Maybe this can help...