Microsoft Office Tutorials and References
In Depth Information
Going beyond Basic Arithmetic
You can format a calculated field so that the result appears in Currency
format in a couple of ways. If you intend to build any forms or reports based
on this query, you can just save the query and forget about formatting the
field. Later, when you’re designing a form or report based on the query,
create a control for the calculated field, the way you do for any other field in
the query; then set that control’s Format property in the form or report to
Currency. The data looks the way you want in the form or report, and you
don’t have to mess around with the query at all.
See Book IV, Chapter 1 for the goods on creating forms and reports. For the
specifics on formatting controls, see the section on setting control
properties in Book IV, Chapter 2.
Optionally, if you have no intention of creating any forms or reports based
on the query, you can use one of the conversion functions to format the
data. Table 2-3 lists some of the conversion functions, all of which are
accessible via the Conversion category of the Built-In Functions folder in
Expression Builder. As usual, you can click a conversion function name in
the third column of Expression Builder and then click the Help button for
more information on the function.
Think of the starting letter C in each conversion function’s name as standing
for “Convert to.” CCur, for example, means “Convert to Currency.”
Be careful when you use a conversion function, because you’re defining
the data type, as well as the appearance, of the calculated field. Setting the
format of a calculated field in a form or report, rather than directly in the
query, is often easier.