Database fields generally display the data that is entered into them. However, a calculated field will automatically figure its value based on values in other fields. Queries often include calculated fields that display values based on other values returned by the query.
To enter formulas in calculated fields:
When using a calculated field to combine text fields, you usually want to hide the text fields that are being combined and show only the new calculated field. |
|
For queries that reference more than one table, you should preface the field name with the table name, with an exclamation point in between. For example, to create a new field called Total that equals the value of the Hours field from the TimeSheet table times 40, you would use the following: |
|
You can also use operators to manipulate text fields. For example, you can use a calculated field to display a new field that combines the values of the FirstName and LastName fields. To do this, use the ampersand (&) symbol to concatenate, or join, the fields. The expression might look like this: |