How do I format a querie result to come out as currency.

  • Thread starter Thread starter DES
  • Start date Start date
D

DES

I'm trying to calculate what the new price of an item would be based on
cutting 10% off of an existing price...I can't get the answer to come out as
currency!
 
I'm trying to calculate what the new price of an item would be based on
cutting 10% off of an existing price...I can't get the answer to come out as
currency!
Click to expand...

Don't confuse data STORAGE with data PRESENTATION.

Let the calculation work in the query; and display the query in a Textbox on a
Form or Report. Set the Format property of that textbox to Currency and you'll
see the result formatted as currency.
 
Back
Top