locked
How to create Access query with format RRS feed

  • Question

  • I am adding one column in the table by the access query

    alter table tpcontact  add IsExisting bit

    oralter table tpcontact  add IsExisting YesNo

    but it's storing 0 or -1 instead o and 1 .

    How to add column with format by the access query?

    Wednesday, August 30, 2017 7:09 AM

Answers

  • but it's storing 0 or -1 instead o and 1 .


    The logic of the most systems is: = 0 means "False" and <> 0 means "True" for boolean; so why do you worry about in internal numeric value?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Teige Gao Monday, September 4, 2017 5:37 AM
    • Marked as answer by Olaf HelperMVP Saturday, November 4, 2017 7:26 AM
    Wednesday, August 30, 2017 8:14 AM

All replies