Where can I find criteria examples for queries?

J

j

I created a table that has yes/no data fields and am unable to query. I
receive an error each time I try. I am looking for a list of common query
criteria.
 
C

Chaim

What do you mean 'unable to query'? How do specify your criteria? Are you
using Yes or No for the criteria value, as in: = Yes
 
M

Michel Walsh

Hi,


With Jet, you can use the field itself

SELECT * FROM myTable WHERE BooleanField


With MS SQL Server, you are likely to HAVE TO use a comparison

SELECT * FROM myTable WHERE SomeField<>0






Hoping it may help,
Vanderghast, Access MVP
 
Top