Format of Calculated Field in Query

[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.

 

[Jeff Boyce]

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

 

[fredg]

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.

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.