Approximation of Values

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

I have created a series of calculated fields in a query that I want the
values to approximate to 2 decimal places when calculating but the program
pick the original value the has not been approximated.....

For examples, if calculated field A = 2,040.2453 without approximation to 2
decimal place and multiplied to B = 250 which is C = 510,062.38

When A * B = C where A = 2,040.25 (approximated to 2 decimal
places).....Access 2007 does not multiple the approximated value of 2,040.25
but picks the original value of 2,040.2453 making C = 510,062.38 instead of C
= 510,062.50 when you multiple 2,040.25 by 250.....
 
Use Round().

For example, to round field A before multiplication, use:
Round([A], 2) *
 
Back
Top