Is it just me? Has anyone noticed odd things on calcs with Access and
Windows7?
A rounding function that has worked for years increases a pence value
by 0.5.
A check for even week numbers SOMETIMES works it out wrong ie
If Int((Weekno /2)) *2 = WeekNo then Ok
is just fine and then an odd time it fails

Then run over and over to test and it works it out Ok, even on Win7
Never had a problem in Vista and earlier, over years of calcs at
different sites

Weird.

Rounding is done for VBA by Windows, and if you never had
a problem that's because you aren't old enough to remember the
last time it changed :~).

Rounding by Windows has always been inexact - they use a
fast rounding method that is Almost Always Correct. (Excel
doesn't use the Windows function, it has it's own correct
rounding function). Since I needed to be at least as correct
as Excel, for the last 10 years I've used my own rounding routines.

Anyway, it may well have changed again. If it's important, have
a look around the web for some of the sample code that does it
properly.

(david)

"elg" <envirocomp (AT) ukonline (DOT) co.uk> wrote