Modify Parameter Query

[Marvin Cervenka]

I have created parameter query [Enter "Y" or "N"]. I am trying to figure out how to modify the parameter query to allow me to query on both the Y/N and not just only the "y" or "N".

Thank You
Marvin

 

[AmjiBhai]

IF statement has an ELSE clause
Case comes with an OTHERWISE clause

Nevertheless you can repeat the individual IF again and again in order to cover all the possible values .