Sum across not= Sum down

E

Eric

I have a table with about 10,000 records. There are nine
long integer fields, SU1,SU2,SU3,SU4,SU5,SU6,SU7,SU8, SU9
that I want a total sum of. None of these are blank. My
problem is that when I do queries for these Sum
(SU1+SU2+SU3+SU4+SU5+SU6+SU7+SU8+SU9) versus Sum(SU1)+Sum
(SU2)+Sum(SU3)+Sum(SU4)+Sum(SU5)+Sum(SU6)+Sum(SU7)+Sum
(SU8)+Sum(SU9),the totals, about 73,500, are about 60
different.
Any Ideas?
 
J

John Spencer (MVP)

Are you positive that there are no nulls in the fields SU1 to SU9?

The results you are getting could be explained by having a null value in some of
the fields.
 
D

Duane Hookom

It sounds like SU1 is the result of a calculation. If so, it would help if
you had explained this fact as well as the calculation in your first
posting. You may need to wrap your field in Val(SU1).
 
Top