Home Forums Programming General Yes/No field in sql server table what is the same RE: Yes/No field in sql server table what is the same

  • Access, I believe simply represents the FALSE boolean value (both in data storage and in VBA script) as -1. Both systems actually just look for the absense of zero, not the existence of 1 or -1. I suppose technically it could be -1, 1, or 5 for that matter since internally, it's looking to see whether the value is 0 or not 0...

    HTH,

    Jay