currency query

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?
 
A

Allen Browne

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))
 
Top