Sum across not= Sum down

  • Thread starter Thread starter Eric
  • Start date Start date
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?
 
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.
 
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).
 
Back
Top