[AccessD] Round function strangeness

Bill Benson bensonforums at gmail.com
Tue Jan 23 12:32:37 CST 2018


What is the data type of a and b?

On Jan 23, 2018 1:15 PM, "Doug Steele" <dbdoug at gmail.com> wrote:

> I used the Round function in a query that had 2 calculated fields. The
> first one was a calculation like a*b+1, the second a straight
> multiplication: a*b. The output from Round(a*b+1,1) was correctly rounded
> to one decimal place. The output from Round(a*b,1) wasn't rounded off at
> all. But when (in desperation), I changed this to Round(a*b+1-1,1), which
> is ridiculous, the output was rounded off correctly!
>
> Any comments?
>
> Doug
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list