Microsoft Office Tutorials and References
In Depth Information
Field properties of a calculated field
Click Format and choose Currency, as shown in Figure B-15. Then click the X in the upper-right corner
of the window to close it.
Currency format of a calculated field
When you run the query, the output should resemble that in Figure B-16.
Query output with formatted calculated field
Next, you examine how to avoid errors when making calculated fields.
Avoiding Errors when Making Calculated Fields
Follow these guidelines to avoid making errors in calculated fields:
Do not enter the expression in the Criteria cell as if the field definition were a filter. You are
making a field, so enter the expression in the Field cell.