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?
|
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). |