Modify Parameter Query

M

Marvin Cervenka

Joined
Jan 31, 2018
Messages
1
Reaction score
0
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
 
Last edited:
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 .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Invalid bracketing of parameter name 1
Creating an update query that uses multiple parameters 2
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Excel Excel 2013 conditional formatting 1
Parameter queries and null values 2
Access Open Form with WhereCondition 6
Access How to Validate the query parameter before loading the form that is based on the query iteself? 2
Access Can't Get Dlookup To Work 1

Back
Top