Calculate Sums with Null Values

[alex243]

I am working on a report that summarizes sums of sales pro category, then a Total of these sums is calculated. The problem is that, if there are no sales in a category, the resulting sum is =0. The Total (of all sums) is then also =0.

So how can I calculate a Total that tolerates sums=0? Do I have to modify the Record Sources of the sales category sums?

 

[KenHigg]

Or you can us Nz() in the record source query.

???
ken

 

[alex243]

How do I do that? Is that a system-defined function?

 

[KenHigg]

Yes it's native Access. I think it goes nz([myfld],0). Where if myfld is null, the place a '0', else use myfld.

???
ken

 

[Rich]

=Sum(Nz([YourField],0))