problem in a query

[azhar2006]

Hello all
It has a problem in a query


I want to add a currency symbol $ in his field in a query
Without recourse to change the settings of your computer

I put this expression, but an error
Expr2: CCur([Expr1]*[Stable],0.0$)

[June7]

CCur() function has only one argument.

Expr2: Format([Expr1]*[Stable], "Currency")

or

Expr2: [Expr1] * [Stabel] & "$"

Could just use the Currency setting in Format property of textbox on form or report.