I have a 'bit' (True/False) column on a table in my DB and for some reason when I run the query I get either "True", "False" or "Blank" when techinically blank isn't even allowed. I was wondering if there is some kind of VB Script or query language that I can get the "Blank" to show up as False, or somehow change the values of "True=1" and "False or Blank=0"
Again this is weird because techinically the column shouldn't be allowing null values so I'm not sure how I'm getting blanks but I am. I did confirm each blank is truly a false.
I know the number of records and the joins I am using are correct but for some reason I cannot get all the report to show the True/False values in each record. EVERYTHING else shows up just fine.
BTW I cannot write to the database I can only query the DB.
Update - The reason they show as blank is because the records are from seperate tables. The joins are correct to show all the data but sometimes there are records that don't use the table with the BIT column so it just shows a blank value. Which just means the value on the report should be False. Not sure if this helps?
Query Problem with Bit column
Posted - 10/04/2012 : 16:38:32
