Problem choosing NULL from Parameter 1

[MikeVac]

I have a multi parameter window. I want one of the values in the pick lists to be null so that users have the choice to say where this particular field is null. I have tried using a * and "" but it won't bring back any records.
Any suggestions

 

[Turkbear]

Hi,
Add a parameter value ( like 'ANY' ) and test for it in your record selection formula, like:

If {?Parameter} = 'ANY'
then
IsNull({table_field})
Else
[table-field} = {?parameter}

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[MikeVac]

Perfect. Thank You Turkbear

 

[Turkbear]

Hi,
Thanks, but I should have recommended a more informative parameter value like 'OnlyIfNull' to help your users understand what they were choosing.







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[MikeVac]

I changed the parameter value to EMPTY. Thanks again.