Rounding Problems

[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

 

[RobFMS]

Here is something you should take a look at:

When Access Math Doesn't Add Up
http://www.fmsinc.com/tpapers/math/index.html

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Guest]

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

 

[jabel]

Also see my discussion of problem here on November 11
http://communities.microsoft.com/NewsGroups/previewFrame.as
p?
ICP=msdn&sLCID=us&sgroupURL=microsoft.public.access.queries
&sMessageID=%253C02df01c3a880%2524c7ef12c0%
(e-mail address removed)%253E.

Jeff

 

[StCyrM]

Hi Scott

Check out this site.

www.fmsinc.com/tpapers/math/index.html

Maurice