Simple Query

[Paul Scott]

Hi all,

I'm using Access 2002 and Sql 2000. I have a form that's
has a check box. I'm trying to create a query that will
display all the false records. I've tried everything I
know to put in the Criteria but nothing works.

Any help would be appreciated.

Thanks and have a good day,

Paul

 

[Jeff Boyce]

Paul

"False" in either Access/Jet or SQL Server is "0". What value are you using
in your query's criterion for this field? I note that you mention a form
with a checkbox, but don't mention if there's actually a table field behind
it with the True/False value.

 

[Wayne Morgan]

Paul,

In addition to Jeff's questions, are you sure the values are False? If you
haven't set a default value of False and the user simply doesn't make a
selection in the checkbox, then the value is likely to be Null, not False.

 

[Michel Walsh]

Hi,

with Jet:

SELECT * FROM myTable WHERE NOT checkControlField


with MS SQL Server (works also for Jet):

SELECT * FROM myTable WHERE checkControlField = 0




Hoping it may help,
Vanderghast, Access MVP

 

[Paul Scott]

It was the 0. I don't know why I didn't think of 0 or 1.
I think I need a vacation.

Thanks for the speedy replies.

Have a good one,

Paul