Format a Query as Currency not Double How??

[Joe M]

How do I format a Query as Currency and not as double.eg
Tax: [Sales] * 1.1
this would default to double ....

 

[Douglas J. Steele]

If Sales is already currency, try:

Tax: [Sales] * CCur(1.1)

If it's not, try:

Tax: CCur([Sales]) * CCur(1.1)

 

[Van T. Dinh]

.... ... or (my preference):

Tax: CCur([Sales] * 1.1)