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.....
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.....