Problems with querying boolean fields created in Access

Last Published: April 25, 2020


If a Boolean field has been added to a dataset using an application such as Microsoft Access, ArcGIS converts this field to a short integer and sets all values that are True equal to 1 (True = 1) and False equal to 0 (False = 0).


A Boolean field contains values of True and False only. Some applications, such as Microsoft Access, use the Boolean field type. Geodatabases and shapefiles do not have a Boolean field.

Solution or Workaround

The selection will not return any records if the statement is written as:

[boolean field] = 1

Use the following statement, as a workaround, to return all records that are equal to a value of 1:

[boolean field] <> 0

The function <> can be interpreted as any value not equal to 0. Since a boolean field only has two values, 0 or 1, the result will yield the selection of values equal to 1.

Article ID:000004783

  • ArcMap 8 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options