Summing if No Records

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

Guest

Hello All

I have a continuous with a textbox in the footer with this formula
=Nz(Sum([Qty]),0)
that I thought would show a 0. I have the form set NO to Allow Additions if
I set it to Yes formula will show a 0.
Could someone please send there intelligence my way

Thanks Mike
 
I do not understand your subject -- "Summing if No Records" -- what would
you expect to total if there were no records?
 
I have a mainform with 2 subforms
On both subforms I have textbox's in the footers that sums Qty.
The subforms are a continuous form. I have a textbox on the mainform that
will sum the 2 textboxes from the subforms. Problem is that when there are no
records in one or both subforms my textbox on the mainform gets the value of
#Error


KARL DEWEY said:
I do not understand your subject -- "Summing if No Records" -- what would
you expect to total if there were no records?
--
KARL DEWEY
Build a little - Test a little


Mike said:
Hello All

I have a continuous with a textbox in the footer with this formula
=Nz(Sum([Qty]),0)
that I thought would show a 0. I have the form set NO to Allow Additions if
I set it to Yes formula will show a 0.
Could someone please send there intelligence my way

Thanks Mike
Click to expand...
Click to expand...
 
Try this:
=IIf(Not IsNumeric(Sum([Qty])),0,Sum([Qty]))

Steve

Mike said:
I have a mainform with 2 subforms
On both subforms I have textbox's in the footers that sums Qty.
The subforms are a continuous form. I have a textbox on the mainform that
will sum the 2 textboxes from the subforms. Problem is that when there are no
records in one or both subforms my textbox on the mainform gets the value of
#Error


KARL DEWEY said:
I do not understand your subject -- "Summing if No Records" -- what would
you expect to total if there were no records?
--
KARL DEWEY
Build a little - Test a little


Mike said:
Hello All

I have a continuous with a textbox in the footer with this formula
=Nz(Sum([Qty]),0)
that I thought would show a 0. I have the form set NO to Allow Additions if
I set it to Yes formula will show a 0.
Could someone please send there intelligence my way

Thanks Mike
Click to expand...
Click to expand...
Click to expand...
 
Back
Top