Rounding Problems

  • Thread starter Thread starter scott vess
  • Start date Start date
S

scott vess

Hi

I am building a query. In the query I have fields that are
multipling numbers together and coming out with long
decimal point answers. I then have it formatted to to
round to two decimal places.

My final field is a calculation to add all the other fields
together. My problem is that when it adds the fields
together it uses the long stored number and not the rounded
number and when you get your answer it does not add up to
the rounded numbers. It is off pennies.

Does anyone know how to fix this problem
Thanks

Scott
 
Scott:

I was having the same problem with supposed "over
accuracy" on computed columns for variables in my queries.
Simply use the Round function such that A=B*C and D=F*G
and then H=D/A use Round H:([D],2)/Round([A],2). Of cource
[D] and [A] are column or fields but usually computed
values in the query.

Jeff
 
Back
Top