Currency field in Table

[Emmy]

I have a table that has a currency field "Amount" which
is a calculated field. No matter what I try, it won't
round to 2 decimal places. The extra digits are causing
my numbers to be off down the line. Does anyone know if
there is a setting in the query that calculates and
populates this field or maybe a setting in the table I
need to change?

Thanks!
Emmy

 

[Allen Browne]

Use Round() in the query expression.

This example multiplies quantity by unit price, adds 6% tax, and rounds the
result to 2 decimal places as a Currency data type:

Amount: CCur(Round(CCur(Nz([UnitPrice] * [Quantity] * 1.06, 0)), 2))