Limiting expression to two decimal points

[JH40]

Can someone show me how to re-write this expression to limit the result to two decimal places? [D], [P], [R] and [C] are just a few monetary columns I am combining for a total owed. When I change the format on the table (this is an update query), it rounds up to the nearest whole number and leaves the right side of the decimal point at two zeros

Collection Percent: -Sum(Nz([P],0)/((Nz([D],0)+Nz([R],0))+Nz([C]+0)))

Thanks!

 

[JH40]

Works great. Thank you!

 

[Petros]

See if this does it for you:

Collection Percent: -Round(Sum(Nz([P],0)/((Nz([D],0)+Nz([R],0))+Nz([C]+0))),2)

Sorry for being "nosy"..but what function does the 2 have?

Thanks!

 

[Petros]

Thanks for the explenation

 

[George21]

If not mistaken, the "Round" simply shows 2 decimals, but the number stored is the actual. For example, the number 3.981 will be stored as 3.981 although, Round(3.981,2) will show it as 3.98.

Any ideas on how to actually store 3.98?

 

[Simon_MT]

Try

Int((Calculation)*100)/100

Simon