YES/No Query Criteria

I Have a query.  I have four fields which are yes/no fields.  In the query I want to be asked to enter Y/N as to build the criteria ad-hoc.  So, I put [Enter Y/N] in the criteria and indeed it prompts me, however what do I enter in the box, as Y or N does not work nor 1 or 0 nor T or F?
PowerhousecomputingAsked:
Who is Participating?
 
slam69Connect With a Mentor Commented:
0 and -1, -1 for a yes
0
 
peter57rCommented:
The only values that will work are -1 (True) and 0(False).

Since this is not intuitive(!!) for the user  you have to work around it.

There is an example of how to deal with it here...
http://support.microsoft.com/kb/198626
0
 
PowerhousecomputingAuthor Commented:
Cool - are there any other options or are they the only?  it just seems odd to tell someone to put in -1 for a yes
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
slam69Commented:
if you use the workarounds as detailed above in the KB then you can easily workaround teh issue
0
 
SreejithGCommented:
Hope my answer helped you to solve your issue.
Folder option setting are per user. Am not sure how to set it for all users.
0
 
SreejithGCommented:
sorry, wrong post.
0
 
rseabirdCommented:
You can try something like this: put it in the criteria box:

IIf([Is he/she married (y/n)?]='y';-1;0)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.