One empty subtotal mucks things up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Have a look in the Help for IIf() and Nz(). Think about
substituting zero for nulls and/or zero length strings.
 
Back
Top