Formatting a calculated field in a query

message from K. Georgiadis on 7 May 2004
I have added a calculated field to a query, using an
expression. How can I format this new field so that it
displays the results in currency format? In the Property
sheet, I see no formatting options for this new field.
 
Van T. Dinh replied to K. Georgiadis on 8 May 2004
Prior to running the Query, Access does not know what type the calculated
value belongs to. However, IIRC, you can simply put the formating String in
the Format row and Access will pick up.

Try typing "Currency" in the Format row.
 
Steve Schapel replied to Van T. Dinh on 08 May 2004
K.,

As another option to Van's suggestion, you can include the formatting in
the calculated expression in the query, i.e.
YourCalculatedField: FormatCurrency(YourExistingCalculationExpression)
 
K. Georgiadis replied to Steve Schapel on 7 May 2004
Your suggestion worked!
the formatting in
(YourExistingCalculationExpression)
type the calculated
the formating String in
 

Archived message: Formatting a calculated field in a query (Microsoft Access Error Message)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.