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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Currency Format in a query 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Currency Formatting Union Query 1
calculated currency field sorts like text instead of numeric 4
Access 2003 3
Currency Format Lost in Union Query 1
Cannot determine casue of overflow error 1
Null value to "0" / Currency format 2

Back
Top