Format of Calculated Field in Query

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi,

I have a calculated field that returns a number that I want to appear as
currency. I have set properties of the field to currency but it has no
effect.

Can anyone tell me what is wrong please?

Ta.
Bill.
 
Bill

You might try coercing the calculated value into Currency type, using the
CCur() function to "wrap" the calculation.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi,

I have a calculated field that returns a number that I want to appear as
currency. I have set properties of the field to currency but it has no
effect.

Can anyone tell me what is wrong please?

Ta.
Bill.
Click to expand...

In a query, use:

Exp:Format(Do your calculation here,"Currency")

i.e. Exp:Format([SalePrice] * [Rate],"Currency")

However, if the query is the record source for a report, I would
probably do the actual formatting (and perhaps the calculation as
well) in the report.
 
Back
Top