Strange Problem (1 Viewer)

[lessthanme5]

Hi,

The Problem that im getting is that when I query select a yes/no field in a table the results return TRUE and FALSE, even when the criteria states Yes.

does anyone know whats going on with it.

I know it isnt me as I have had my collegues check it over and they are all confused as well.

any help will be great!

 

[selenau837]

Hi,

The Problem that im getting is that when I query select a yes/no field in a table the results return TRUE and FALSE, even when the criteria states Yes.

does anyone know whats going on with it.

I know it isnt me as I have had my collegues check it over and they are all confused as well.

any help will be great!

Copy and paste your SQL statment.

Perhaps looking at that will help us determin the problem for you.

 

[KeithG]

In the query right click on the field and choose properties and change the format property.

 

[lessthanme5]

Ill check to see if Keiths will work first and then I will paste the code

 

[neileg]

True/false yes/no -1/0 are three different ways of seeing the data. What is actually stored is -1/0.