[AccessD] Round function strangeness

Doug Steele dbdoug at gmail.com
Tue Jan 23 12:12:33 CST 2018


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


More information about the AccessD mailing list