Currency Format in Query

  • Thread starter Thread starter L.A. Lawyer
  • Start date Start date
L

L.A. Lawyer

I have a generated field in a Query which I want to have as a currency
field. It generates the number fine (this is the division result of a
current amount and a plain number), but the output is always a plain number,
no matter what I do. I tried formatting the result as Format(Result,
"Currency"), but that didn't work either.

What gives?
 
L.A. Lawyer said:
I have a generated field in a Query which I want to have as a currency
field. It generates the number fine (this is the division result of a
current amount and a plain number), but the output is always a plain number,
no matter what I do. I tried formatting the result as Format(Result,
"Currency"), but that didn't work either.

What gives?

.
Click to expand...

This works for me in a query..
NewField:Format([FieldA]/FieldB],"Currency")

Why bother formatting it at all in the query if you are going to use the
result in a report, or on a form?

Format it in the report/form:
=Format([YourField],"Currency")
or:
=Format([YourField],"$ #,###.00")

You can omit the $ if you don't want it to see it.
Make sure the name of the control is not "YourField".
 
Back
Top