Convert to currency

[eugz]

Convert value format in query

Hi All.
In my calculation in a query:
Cost: Sum([Cost]/12*(DateDiff("m",[StartDate],Now())))
Cost is Currency;
StartDate is Date.

The result look like Numeric format I would like to have Currency format. Is it possible?
Thanks.

 

[EMP]

You can use the CCur() function.

^