DISCOVER
×

How to Add a Blank Field to an Access Query

Updated April 17, 2017

Adding blank fields to an Access query can be done by utilising the empty query columns when the query is in Design View. The blank field is added by adding a simple Access expression or formula in the blank column. Once this formula is created in the Query Design View, run the query to see the results of the query blank formula. The blank field can be used for alignment purposes.

Open Access 2010 and select a database. Click the "File" tab and one of recently used databases in the File menu. The database opens.

Click the "Create" tab and select the "Query Design" icon. The Show Table dialogue box appears. Click the table name and the "Add" button to add the table to the query. Close the "Show Table" dialogue box by clicking the "Close" button.

Add your table fields to the query by clicking the field name and dragging them into the query. Create a blank field by clicking in the next blank column in the query. Type a name for the column and include a colon after the name in the column's "Title." For example, if the name of your column is Data, enter "Data:" "." To create the blank column, enclose a space with quotations. The completed expression will look like this: "Data: "" ."

Run the query by clicking the "Run" button. Review the query results and the blank Data column in the Query Datasheet View.

bibliography-icon icon for annotation tool Cite this Article

About the Author

Emmanuelle Douglas has been an avid writer since 1990. Her first professional writing assignment was for "Oscar News," a local corporate Intranet website. She holds a Bachelor of Science in mathematical sciences from Clemson University.