• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Using Microsoft Query > Managing Boolean Fields and Check Boxes

Managing Boolean Fields and Check Boxes

One annoyance involved in bringing data from a database to the worksheet is due to Boolean fields. Booleans are also termed True/False fields, and Access often refers to them as Yes/No fields.

Boolean fields take one of just two possible values: True and False. Difficulties arise when you return their values to the worksheet because databases don't necessarily store them as TRUE or FALSE, the values you normally see on an Excel worksheet. You need to account for this, either in the database or in Excel. And check boxes, which usually result in either a True value (checked) or a False value (unchecked) can have a third value, Null (shaded).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint