View Full Version : Yes/ No sorting


CGirl
04-18-2002, 07:44 AM
New to Access and was wondering if I had 3 yes/no questions in a query, can I pull up the records if any of these =true?

Graham T
04-18-2002, 07:51 AM
To pull out records if they are True (i.e. Ticked) use: Yes, True, On or -1 as criteria.

For false use: No, False, Off or 0.

HTH

CGirl
04-18-2002, 10:34 AM
I see what you mean. I need for only 1 out of the 3 to be true. The way I have it, all of them have to be true before it pulls the record up. I have each one =yes, but as long as one of the values are true, then I need to know it. Is there such a thing as an OR statement?

kavarin
04-18-2002, 12:10 PM
To me, it sounds as though you would better off with an "IF" statement rather than an "OR" statement in your query
Example:
Show FIELD1 IF xxx=True...
and include each of the three fields in the query. Does that make sense??

HTH too-

Graham T
04-19-2002, 03:09 AM
CGirl

Can you just not add the True criteria to the three seperate rows of the grid so:

Column A is true, OR Column B is True, OR Column C is True?

Graham

David R
04-19-2002, 07:00 AM
If you place the criteria all on the same row of your query, Access requires them ALL to be true. If you place them staggered on different rows, ANY can be true. Different combinations form different logical statements (check the SQL view if you want to see this in a slightly more textual format).