Bit Data Type Issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Access 2003 front end/back end application. A table in the back end
has a field data type of Yes/No. I used the Upsize wizard to convert the
back end to SQL 2000. It converted the yes/no data type to bit data type
with 1's and zeroes. In the Access front end (which uses ODBC to access the
linked back end tables) the 1's appear as -1 and the zero's are zero. Why is
that?

Now to the issue. Queries don't work properly. In my query criteria, if I
specify to select only the zero (which I think are false or No) values, it
doesn't return any records. If I don't specify any criteria, it returns all
the records and I can see zero values. Any ideas?
 
Rob,

Thanks for your reply. I know what you said. To further address the issue,
I have a text field named Reason_Code and a bit field named
FMLA_Transaction_Complete. There is a record with a reason code of "F" and a
FMLA_Transaction_Complete value of 0.

Query follows:
SELECT Absences.Reason_Code, Absences.FMLA_Transaction_Complete
FROM Absences
WHERE (((Absences.Reason_Code)="F") AND
((Absences.FMLA_Transaction_Complete)=False));

This yields no data! Does that make sense?
 
Back
Top