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.
- Skill level:
Other People Are Reading
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for