General discussion
November 23, 2004 at 02:54 PM
dvgoad

fractional value not equal to the sum

by dvgoad . Updated 21 years, 8 months ago

Using MSAccess 2002. Report with three columns of numbers. Column 1 is a whole number. Column 2 is a percentage formatted as percentage with 2 decimal. Column 3 formatted standard with 0 decimals. The math across rounds up/down correctly. However, when I add column 3 down… it doesn’t add up!!!

EXAMPLE:
Column 1 is a given number.
Column 2 is the percentage.
Column 3 = column one * column two
47,320 32.93% 15,582
47,580 33.29% 15,839
47,300 33.39% 15,793
47,280 33.22% 15,706
47,680 32.48% 15,486
47,260 33.37% 15,771
47,200 33.02% 15,585
Total in Access: 109,764
On Calculator: 109,762

Where did two go? Is there special formatting I need to do in column 3 as well as the total field?

This discussion is locked

All Comments