Edit Access Query YES/NO field check boxes in 2010... get rid of -1's and 0's!

[accesssux]

Hi, I'm an access layperson. I took a semester long course during college on access and am stuck working for a small business making the database. Please, try not to type any jibberish to me in respons to my question that has things like { \ [d[]][~ since I will not understand unless you write it out in a very simple manner.

So, in 2007 I could make editable queries with yes/no check boxes. Now when I try to do them... they give me NEGATIVE ONES AND ZEROS.. Why couldn't they just be ones and zeros?!?! why negative ones?!?!?! How do I stop this from happening!??!?! Please, help me!

[TheShabz]

a Yes/No box is a True/False Boolean indicator. In Access, -1 represents True and 0 Represents False. It is the same with many other database systems.

Checked Box = True = -1
Unchecked Box = False = 0

So in your table, you would see a checkbox. However, in a query you would use either True and False or -1 and 0