[AccessD] Round function strangeness

Doug Steele dbdoug at gmail.com
Tue Jan 23 13:02:05 CST 2018


singles. The calculations worked fine, it was the rounding that failed.

On Tue, Jan 23, 2018 at 10:32 AM, Bill Benson <bensonforums at gmail.com>
wrote:

> 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
> >
> --
> 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