Sum is Null

[DS]

I have an unbound textbox on a report footer and if it's null or on error
comes up I want a 0 to appear. This is what I have and it doesn't seem to
work.

=Nz(Sum([PayAmount]),0)

I just get an #Error.

Anu help is appreciated,
Thanks
DS

 

[Marshall Barton]

I have an unbound textbox on a report footer and if it's null or on error
comes up I want a 0 to appear. This is what I have and it doesn't seem to
work.

=Nz(Sum([PayAmount]),0)

That PayAmount name in the expression MUST be a field in the
report's record source table/query. It can not be the name
of a control on the report.

 

[DS]

PayAmount is a field in the reports record source.
Thanks
DS

I have an unbound textbox on a report footer and if it's null or on error
comes up I want a 0 to appear. This is what I have and it doesn't seem to
work.

=Nz(Sum([PayAmount]),0)

That PayAmount name in the expression MUST be a field in the
report's record source table/query. It can not be the name
of a control on the report.

 

[Guest]

Are you sure your text box is in the report footer and not in the page footer?
--
Duane Hookom
Microsoft Access MVP

PayAmount is a field in the reports record source.
Thanks
DS

I have an unbound textbox on a report footer and if it's null or on error
comes up I want a 0 to appear. This is what I have and it doesn't seem to
work.

=Nz(Sum([PayAmount]),0)

That PayAmount name in the expression MUST be a field in the
report's record source table/query. It can not be the name
of a control on the report.

 

[Guest]

If you would have mentioned "when there are no records" in your first post,
Marsh would have provided the correct reply in his post.

=IIf(HasData=True, Nz(Sum([PayAmount]),0),0)

--
Duane Hookom
Microsoft Access MVP

Definitley in the report footer. When there are records it works fine, only
when there are no records I get an #Error. Is it incorrect to use this on
no records?
Thanks
DS

Are you sure your text box is in the report footer and not in the page
footer?
--
Duane Hookom
Microsoft Access MVP

PayAmount is a field in the reports record source.
Thanks
DS
DS wrote:

I have an unbound textbox on a report footer and if it's null or on
error
comes up I want a 0 to appear. This is what I have and it doesn't seem
to
work.

=Nz(Sum([PayAmount]),0)


That PayAmount name in the expression MUST be a field in the
report's record source table/query. It can not be the name
of a control on the report.

 

[DS]

Definitley in the report footer. When there are records it works fine, only
when there are no records I get an #Error. Is it incorrect to use this on
no records?
Thanks
DS

Are you sure your text box is in the report footer and not in the page
footer?
--
Duane Hookom
Microsoft Access MVP

PayAmount is a field in the reports record source.
Thanks
DS

DS wrote:

I have an unbound textbox on a report footer and if it's null or on
error
comes up I want a 0 to appear. This is what I have and it doesn't seem
to
work.

=Nz(Sum([PayAmount]),0)


That PayAmount name in the expression MUST be a field in the
report's record source table/query. It can not be the name
of a control on the report.

 

[DS]

Sorry Duane, sometimes I stay up to late and become forgetful !
Thank you for the answer!
DS

If you would have mentioned "when there are no records" in your first
post,
Marsh would have provided the correct reply in his post.

=IIf(HasData=True, Nz(Sum([PayAmount]),0),0)

--
Duane Hookom
Microsoft Access MVP

Definitley in the report footer. When there are records it works fine,
only
when there are no records I get an #Error. Is it incorrect to use this
on
no records?
Thanks
DS

Are you sure your text box is in the report footer and not in the page
footer?
--
Duane Hookom
Microsoft Access MVP


:

PayAmount is a field in the reports record source.
Thanks
DS
DS wrote:

I have an unbound textbox on a report footer and if it's null or on
error
comes up I want a 0 to appear. This is what I have and it doesn't
seem
to
work.

=Nz(Sum([PayAmount]),0)


That PayAmount name in the expression MUST be a field in the
report's record source table/query. It can not be the name
of a control on the report.