Calculation wrong

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

My problem is rounding, but can't figgure out how to solve
it.
I have 7 fields which are involved
some are multiplying and some are substraction, All are
involved after I multiply the first field by 1.0675
the calculated results are off 1 cent. due to no rounding
How can I get it to calculate results in 2 decimals and
get accuraate results.
I can find nothing in my books or anywhere I look in
options or properties. All fields are set to currency
Thanks for any help
Roger
 
Thanks
Haven't tried it yet, I assume it goes
in the critirea field.

Roger
-----Original Message-----
If you use A2K or later, try:

Round([FirstField]*1.0675, 2)....

--
HTH
Van T. Dinh
MVP (Access)



Roger said:
My problem is rounding, but can't figgure out how to solve
it.
I have 7 fields which are involved
some are multiplying and some are substraction, All are
involved after I multiply the first field by 1.0675
the calculated results are off 1 cent. due to no rounding
How can I get it to calculate results in 2 decimals and
get accuraate results.
I can find nothing in my books or anywhere I look in
options or properties. All fields are set to currency
Thanks for any help
Roger
Click to expand...


.
Click to expand...
 
Back
Top