How do i make a Query in Microsoft Access that shows A or B not A and B?

Erica D · #1 (**permalink**) 11-08-2007, 04:33 PM

example question: Make a Query that looks for all widgets that are either Green OR Fuzzy. Show all fields in the answer.

Expolorer · #2 (**permalink**) 11-08-2007, 04:33 PM

Select * from yourtable where searchfield = 'Green' or searchfield = 'Fuzzy'

hope this helps..

SCORCEL D' Polygon · #3 (**permalink**) 11-08-2007, 04:42 PM

select * from widgetsTable where widgetsColor='Green' or widgetsColor='Fuzzy'

Barry · #4 (**permalink**) 11-08-2007, 05:00 PM

select * FROM widgets where something = 'green' or something = 'fuzzy'

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode