Rounding numbers to 2 DP

[Craig Dovey]

I am multiplying numbers in two fields to return a number to a third field.

I use the following formula

Field3 = Round( Field1 * Field2 , 2)

This works fine - however when the answer is exactly 0.5, 1.5, 2.5 etc.. it
will round up rather than round down.

Does anybody know the solution to this problem?

Thanks

 

[Sean]

Example?
What is the number of Field1, 2, 3?

 

[Craig Dovey]

all fields are have format - double

Example?
What is the number of Field1, 2, 3?

 

[Sean]

I mean what is the value of Field 1, 2 and 3 in your scenario?

 

[RobFMS]

In addition, what are the data types assigned to the fields?

This technical paper may offer you some insight into Access math.

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

HTH
--
Rob

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

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

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