Sum returns Zero only

[mboe]

I have a table made up of imported data with a couple currency fields. I am only having problems with one field. It will show up in a query but if I do a sum on the field it returns zero. I checked the type and it imports as a decimal. One of the other currency fields I imported is formated as long integer. I tried changing the format but it still won't sum.

Is formating the problem or is it something else?

...I must not be thinking straight today!

 

[dcx693]

Are there Null values in that field?

 

[mboe]

I figured it out. I was right, I just wasn't thinking straight yesterday. The table had some records it shouldn't have had and they made the balance come out to zero. Never underestimated the value of a good nights sleep!!