How to create parameter where field <> 0.00

[veronic]

I need to create a parameter where user should be able to select all records or records where Balance <> 0.00. I am missing something very easy....but


Thank you

 

[lupins46]

Not simple.

In your query, add an extra column:
test:iif(isnull([Enter exclude value]),true,Balance<>[Enter exclude value])

Then in the criteria for this column put : True

When you run the query, click Ok on the parameter prompt if you want all records; enter a 0 if you want non-zero values.
(Obviously(?) you can enter any value in the parameter and it will exclude records with a matching balance)
Make sure that the parameter text is exactly the same in both cases.

 

[veronic]

thank you very much. I'll try