You don't always have to type your calculated field expressions. The Expression Builder lets you construct expressions with just a few clicks of the mouse. It even has a built in checker, so you'll know right away if you've made a mistake.
To create a calculated field with the Expression Builder:
When you create a new calculated field, by default, Access will set the Show option to off. Be sure to check the Show check box, or your new field won't show when you run the query. |
|
When you create a calculated field with the Expression Builder, Access will automatically name the field "Expr1". Rename the field by clicking in the field name box and typing the name you want. Be sure not to delete the colon after the name Access needs this to know that this is a calculated field. |
|
You can create some very sophisticated expressions with the Expression Builder. Be sure to explore the features available in the Functions and Common Expressions folders. |