Select Yes or All (yes and no)

H

hmaze

In a query, how can I select 'yes' records or all (yes and no records). I
either want to see only yes-records or all records.

Thank you.
 
A

Amy Blankenship

SELECT * FROM YourTable WHERE YourField = Like [Enter Condition]

When the dialogue comes up, either enter -1 (Yes) or * (All)

HTH;

Amy
 
F

fredg

In a query, how can I select 'yes' records or all (yes and no records). I
either want to see only yes-records or all records.

Thank you.
Click to expand...

WHERE YourTable.CheckField =-1 OR [All?] Is Null;

When prompted, enter anything and click OK to return all the records.
Just click OK (without entering anything) to get just the Yes values.
 
Top