Total Calculation

[Terry]

I have a Grand Tot Field that totals 14 other fields on a form. Works great
unless one of the fields is empty, in which case the calculation returns
nothing. I know that I can set the default value of the fields to 0 so that
does not happen, but I want the underlying table fields to remain empty if
the value would be 0, so setting the default is problematic.

Question - is there a way to calculate a sum of those fields if several of
them are empty?
Terry

 

[Dennis]

=Nz([Field1],0) + Nz([Field2],0) etc.

 

[Keith Wilby]

I have a Grand Tot Field that totals 14 other fields on a form. Works great
unless one of the fields is empty, in which case the calculation returns
nothing. I know that I can set the default value of the fields to 0 so that
does not happen, but I want the underlying table fields to remain empty if
the value would be 0, so setting the default is problematic.

Question - is there a way to calculate a sum of those fields if several of
them are empty?
Terry

Yes, calculate the totals in a query and use the Nz (null-to-zero) function
to convert nulls into, erm, zeros!

Keith.
www.keithwilby.com

 

[Terry]

Thanks

Yes, calculate the totals in a query and use the Nz (null-to-zero)
function to convert nulls into, erm, zeros!

Keith.
www.keithwilby.com