One empty subtotal mucks things up

[nick]

Hi,

I'm building an invoice system. My invoice has 3 subforms, each of which has
a subtotal, =Sum([cost]). Then at the bottom I record the sum of the
subtotals.

It works fine unless one of the subforms has no records. Then the subtotal
AND the total both come up blank. Is there a condition statemen I can use
that will set the subtotal to zero if there's no records?

Thanks

 

[Nick Coe \(UK\)]

Have a look in the Help for IIf() and Nz(). Think about
substituting zero for nulls and/or zero length strings.