I have created a parameter with 2 default values (YES NO) that the user can select only one of them. This parameter DOES NOT match any value in my dataset table. What I want to use this for is selecting only data records with On Hand balance records when they select the YES and select all records when they select NO. How do I use this parameter with in dataset query for 2 different tests for the On Hand either <> 0 or exclude the On Hand test al together? Image shows my parameter with the YES NO.
I need to use this parameter in my query, testing to see if they selected YES, then include the test for On Hand ,. 0. Else leave out this test. second image shows my query.