How to Perform Calculations in a Query in Access

Perform calculations in a Access query by adding formulas to a query.

Access queries let you define your output in Access. Using queries, you can select fields from various tables and queries. You can also create custom calculations based on fields added to the query. Calculations are created in the design view of the query. The calculations are made by creating formulas that use operators and functions. Once the formulas are complete, run the query to see the results of the formula in the query data sheet view.

Instructions

1. Open Access 2007 and select a database. Click the "Office" button and select "Open." Browse your computer for the database. Locate the database. Click the database and click "Open." The database opens.

2. Click the "Create" tab and select "Query Design." Select tables from the Show Table dialog box by clicking the "Add" button. Click "Close" to close the Show Table dialog box.

3. Add fields in the query by clicking the field name and dragging the field to the query window. Click in a blank field in the query window and type your formula in the "Field Name." The formula must begin with an "=." Enclose the field name in the formula within brackets. Here is an example of a sample query formula calculation:

   "=[Invoice_Total]*.07"

4. Perform the calculation by running the query. Click the "Run" button the ribbon. Review the calculation results in the query data sheet view.

References

• Microsoft: Create an Expression

Resources

• Microsoft: Access How To & Help