Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006

    Unanswered: Convert a bit to a flag/Boolean

    I am referencing with a MSAccess Query a column in an (SQL) database. This column is of type (bit, not null). From within the Query, how do I convert it to a boolean so that I can compare it to the values True/False. Not too sure but I think the equivalent question is how to convert a data type bit (0/1) to a datatype Boolean (True/False) in MSAccess/VB?

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Multiply by minus one (-1).

    Just guessing, but I do know that in Access, False is ZERO and True is negative 1 (-1). Since a bit is zero or 1, multiplying it by -1 should make it True/False compatible.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Feb 2004
    One Flump in One Place
    I would avoid trying this for now - stick with your original question. I didn't answer as I've not had this problem for over 4 years and have forgotten the precise issues. Converting to Access Boolean is unlikely to yield much.
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts