sum blank cells into query total

[Orozvik]

HI,
interesting one here. See if anyone can help. I'm washed up at this point.

I have cross tab query results in a table. There are sales columns across the top, one for each month or 12 in total. These are rows of sales data...say parts. Well, some of the parts weren't sold during certain months and thus there are no values in the related month field and row cell. When i create a column in my query which utilizes this table to sum up each of the twelve months, it only returns a value for where there is a value in every month field. In otherwords, where there is a blank for any given month, it will not provide a total. Example. We sold widgets in only two months last year. February @ 50 and December @100. All other months show a blank across this row. IN the query, i would expect the total field which states in teh build fuction to add each column as in [01]+[02]+[03]...etc....to return 150, but the buger leaves the total blank. What is up with this?



Can you help? thx.

[Sibtain]

Encapsulate the Sum method within the decode function and convert the null value to zero it will resolve the issue

Regards