How to Add a Blank Field to an Access Query

Written by emmanuelle douglas | 13/05/2017
How to Add a Blank Field to an Access Query
(Jupiterimages/Brand X Pictures/Getty Images)

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.

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.