Format a Query as Currency not Double How??

Joe M · Oct 30, 2003

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 · Oct 30, 2003

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 · Oct 31, 2003

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

Tax: CCur([Sales] * 1.1)