Difference in round off

[kkshansid]

Function da(BP, DP)
da = Round(139 / 100 * (BP + DP))
End Function

In Function da returns to be 7297 but in the immediate window which is correct ?ROUND(139/100*(3500+1750) )
7298
I checked through debugging too that in the function also bp=3500 and dp=1750

I can't get the reason behind it.
Kindly Help
Thanks in advance

ACCESS 2007

[TheSmileyCoder]

Your problem arises from lack of the definiton of your variable types. You have not informed access what to expect as input, whether the input is apples or oranges or numbers.

When access finds a undeclared variable it assumes it to be a Variant. Your function statement is equivalent to:

Public Function da2(bp As Variant, dp As Variant) As variant
   da2 = Round(139 / 100 * (bp + dp))
End Function

Which also yields 7297.

A correct functional statement could look like:

Public Function da3(bp As Double, dp As Double) As Double
   da3 = Round(139 / 100 * (bp + dp))
End Function

which returns 7298.