Creating Queries  «Prev 

How to create a calculated field

This table contains information about sales. Salespeople receive a 10% commission, and I want to calculate that
This table contains information about sales. Salespeople receive a 10% commission, and I want to calculate that

In order to create a calculated Commissions field I first create
In order to create a calculated Commissions field I first create a new query that contains the Sales table.

In order to see all the fields in the Sales table
In order to see all the fields in the Sales table, I double-click the asterisk(*) in the table box, this tells Access to display all fields from the Sales table in the query datasheet

Type the expression for the new field into the Field row of the first empty column
Type the expression for the new field into the Field row of the first empty column. The expression is in this form:
New Field Name: expression. Notice that instead of an =(equal sign), a : (colon) is used, this is required in query expressions.

The datasheet show the new field commission
The datasheet shows the new field, Commission