How to Query Blank Fields in Access

By Emmanuelle Douglas

Access queries extract data out of the database by letting you specify fields and criteria. When constructing the query using the design view, you can add the fields that need to be displayed in the output. This query result is enhanced when criteria is added. Query criteria lets you refine the results by specifying for what you are looking. When searching for blank fields, use the "Null" expression to query blank fields.

Step 1

Open Access 2010 and select a database. Click the "File" tab and select "Open." Search the files and locate the database. Double-click the database to open it.

Step 2

Click the "Create" tab on the ribbon. Select "Query Design." The Show Table dialog box appears. Click a table name and the "Add" button to add the table to the query. Click the "Close" button to close the Show Table dialog box.

Step 3

Add some fields to the query by clicking the field name and dragging them into the query columns. In the field that may contain blank fields, add your query criteria. Click in the "Criteria" field and type "Is Null."

Step 4

Run the query with blank fields by clicking the "Run" exclamation button on the ribbon. Review the records with blank fields in the query datasheet view.