Help With a Query Please

twosides

Registered User.
Local time
Today, 15:00
Joined
Jul 19, 2005
Messages
38
Hi Folks,
I have one table with say 4 fields, Name, Address, Size, Order and InStock.
Order and InStock are checkboxes.
I want a query that displays records that have a -1 status in 'Order' OR 'InStock'.

Any help would be apreciated.
Thanks
 
SELECT * FROM [Table Name] WHERE [Order]=-1 OR [InStock]=-1


Rhe -1 must be in quotes ("-1") for each field that is of a text datatype.
 

Users who are viewing this thread

Back
Top Bottom