Rounding a number in access

[xmattxman]

I have a field that looks like this
Total_Amnt: [SH_QTY]*[Price_Disc]

An example of my outcome is 1074.528.


I need that number to round to 1074.53. I am not sure how to go about doing that. Any help would be appreciated!

[pbaldy]

Check out the Round() function for starters.

[June7]

Be aware Round() function in Access uses banker's (even/odd) rounding.

Round(4.65,1) = 4.6

Round(4.55,1) = 4.6

[davegri]

I suggest using Decimal and specify scale and precision properties in the table.
Precision is the total number of digits allowed in a number, including left and right of the decimal.
Scale is the number of digits allowed to the right of the decimal.


So 1234567.89 has a precision of 9.
123456.789 has a precision of 9 and a scale of 3.


A precision of 4 and scale of 2 would result in a number with a maximun value of 99.99


Percent designations like 125.5% would require precision 4 and scale of 3 (not one) since it is actually stored as 1.255.


Precision has a maximum value of 28, but textboxes in forms allow only a max of about 15 decimal places.

[xmattxman]

Thanks for the help guys! I used the precision scale in the table properties and that fixed my issues!