V VIK Jul 30, 2004 #1 Does anybody have an idea as to how to change the currency default from 4 decimal places to 2 in a calculating query?
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 Jul 30, 2004 #2 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))
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))
