currency query

  • Thread starter Thread starter VIK
  • Start date Start date
V

VIK

Does anybody have an idea as to how to change the currency
default from 4 decimal places to 2 in a calculating query?
 
Currency is a fixed point number, and always has 4 decimal places.

You can force it to round to 2 places in a calculated field of a query, by
typing something like this into the Field row:
Round([Amount], 2)

More reliable:
CCur(Nz(Round([Amount], 2), 0))
 

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

How do I get Access to append the exact amount with decimals? 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
percentage calculation...trying again 26
percentage calculation 2
Its Null values again! 1
Report totals off by a couple cents. 4
calculated currency field sorts like text instead of numeric 4
Decimal Field's Precision Too Small to accept the numeric you ... 3

Back
Top