Are you aware of the algorithm Access uses for rounding numbers ending in 5
(in the place just past the least significant one)?
The number is rounded to the nearest even number - thus 4.5 rounds to 4,
but 3.5 also rounds to 4.
I don't know whether this is relevant to your case, but it's worth knowing
any time you're rounding.
And as others have stated, it hasn't changed in a long, long time.
Of course if you haven't changed the query, the question arises whether
you've(or someone else has) changed any of the data?
Do you have backup copies of earlier datasets? Do they still return the
same numbers?
<dh**********@wrha.mb.ca> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
I have a query that uses the Round function to change decimals into
whole numbers. For 4 years straight the thing has always rounded the
numbers in exactly the same way so that whenever I update my graphs,
the percentages for the historical data are always exactly what they
were the last time I ran the query. Now, for the first time my
percentages are all just slightly off and I have not changed the query.
The only thing I can think of is that it is rounding the numbers
differently. I have not upgraded to a new version of Access or
anything, so why would this be? The data types are all long integer.