Creating Queries  «Prev 

How to Create Calculated Field in Access

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

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

3) 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

4) 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.

5) The datasheet shows the new field, Commission