sum

T

Ted Allen

Try using the Nz() function, which will substitute 0 (or
any other value you specify) for Null. For example:

Nz([Field1],0) + Nz([Field2],0)

-Ted Allen
-----Original Message-----
I am trying to Sum 2 fields in a query. When either one
Click to expand...
of them as no data but one does it will not total. It
only works if I have values in both. How do I get it to
sum each item even with null values?
 
Top