You can also click Run in the Results group in the Query Tools Design tab in the Ribbon. Right-click the tab for the query and select Datasheet View.If you are in the Zoom dialog box, click OK.In the expression, enter any operators or functions as appropriate (+ for addition, – for subtraction, / for divide and * for multiply).For example, you could enter Variance:- in the field row or Zoom dialog box. You can right-click in the field row and select Zoom or press Shift + F2 to "zoom in" to make it easier to enter the expression. When you enter field names in the expression, they should appear in square brackets such as. After the new field name and the colon, enter the expression.Also, do not use the same name as another field in a table in your database. When you enter the name of the new field, do not use periods (.), square brackets () or exclamation marks (!). Anything after the colon is part of the mathematical expression used in the field. In the grid, in a blank column in the Field row, enter the new field name followed by a colon (:).Double-click the desired tables and then click Close.Click the Create tab in the Ribbon and then click Query Design in the Queries group.To create a select query with a calculated field (which would appear in each record in Datasheet View): Recommended article: 10 Microsoft Access Tips for Working with Select Queries Creating a calculated field in a select query Calculated fields can also be created in other types of Access queries. You'll need to learn a few syntax rules and then you can create simple to more complex calculations. You can create calculated fields in select queries in Microsoft Access in the QBE (query by example) grid. Create Calculated Fields in Microsoft Access Select Queriesīy Avantix Learning Team | Updated April 9, 2021Īpplies to: Microsoft ® Access ® 2010, 2013, 2016, 2019 and 365 (Windows)