Summing if No Records

[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

 

[Guest]

I do not understand your subject -- "Summing if No Records" -- what would
you expect to total if there were no records?

 

[Guest]

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

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

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

 

[Guest]

Try this:
=IIf(Not IsNumeric(Sum([Qty])),0,Sum([Qty]))

Steve

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

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

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