Boolean field not recognizing 0

  • Thread starter Thread starter Mark A. Sam
  • Start date Start date
M

Mark A. Sam

Hello,

I am running Access Queries against SQL Server linked table. I am having a
problem with boolean fields where they don't recognize 0 in some fields but
do in others, so if I want to test a field for zero (false) I need to say:

[field] = 0 or [field] is Null

rather then

[field] = 0

The fields in question are all populated with 0 values. Does anyone know
what the problem is?

God Bless,

Mark A. Sam
 
I solved this by using an update queery to set the value in all records to
0. I think I had this problem recently and forgot about it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dynamic calculated field in query 3
Query for not 0 4
DSum update query with multiple fields 0
Split data in field on character return 0
Calculated Field as Boolean 1
Count <>0 not working 3
Can't insert record 3
Convert boolean constant to a number 1

Back
Top