Formatting a calculated field in a query

  • Thread starter Thread starter K. Georgiadis
  • Start date Start date
K

K. Georgiadis

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.
 
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.
 
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)
 
Your suggestion worked!
-----Original Message-----
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)

--
Steve Schapel, Microsoft Access MVP


.
Click to expand...
 
Back
Top