Geting result set to print only Checked records

[Guest]

How do I write a criteria statement for the sales column where only sales are
retrieved in the result set? My sales column is a yes/no data type. I know
that I want to use the <> to show that the sale entry is not null but I don't
know how to write the statement. Thanks.

 

[Crystal]

Since you want to use the sales for criteria, it is not
necessary to test it for null (null values won't be checked )

SELECT * FROM Tablename WHERE Sales;

since Sales is True (Yes) or False (No), you do not need to say

Sales = true
--> this is like saying
True = True


Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com