weird query problem > Access & SQL Server!?

J

Jerome

I've made a query that should use a boolean value as criteria.
The query is in Access, the data on SQL Server.

When the criteria is YES (or True), the query brings the correct result.
When the criteria is NO (or False), the query brings no results at all!?
Though there are records fitting that criteria ...

Anyone know how I can query those NO-records??

Thanks a lot.
 
R

Richard Myers

Are you sure that the (nos) are in fact (nos) and not nulls? If so then
show us your SQL.

Richard
 
J

Jeff Boyce

Jerome

You didn't provide the SQL statement, so it's a bit tough to help
diagnose...

One possibility is that you need to compare to 0 (zero) for False and not-0
for True.
 
J

Jerome

That was indeed the problem! Silly me ...

Thanks for bringing that up. I updated the nulls to nos, and now it works!
 
Top