Records will not sum together?

[memario1214]

I have some values in one of my tables and I need the sum of them in a report. This total needs to be a column. The fields are named 4 in, 6 in, 7 in, 9 in, 11 in. Not quite sure why they just will not add together in a report or even a query. Very simple thing. Most of the time I am getting blank cells. If I try it in a report I get 0's. Any help?

[RayMilhon]

Question: are the fields mutually exclusive. So say the 6 in field has data are the rest of the fields in that record null?

[memario1214]

Most of the time no. I need to sum the values in the 6,9,etc fields. Sometimes only one will have a value but more often than not that's not the case

[RayMilhon]

The Nulls are probably the use. My recommendation is that you either default numeric fields to 0 so there are no nulls or use the "total:Sum(IIF(isnull(numericfield),0,numericfield ))" in your query.

[RayMilhon]

that should have been issue not use in the first sentence.

[memario1214]

EDIT: Nevermind. I just pulled a NO DUH! Thanks