Does anyone know of a way to do summations on data in a crosstab query that contains null values? For example, Here is the dataset of the crosstab query:
item 2002 2003 2004
1 56 56 56
2 48 49
3 674 828 916
4 12 5
5 51
When I refer to this query in a report and attempt to do a sum function on the year, the result is null for any row that has a null value. Any ideas???
Thanks!
item 2002 2003 2004
1 56 56 56
2 48 49
3 674 828 916
4 12 5
5 51
When I refer to this query in a report and attempt to do a sum function on the year, the result is null for any row that has a null value. Any ideas???
Thanks!