show 0 in section footer if total is 0

[Emma Aumack]

I have a report that totals in the section footer. Everything is fine if
there is a total. However, when the total is 0, nothing is displayed. I
would like it to display "0" as the total.

I am totalling in an unbound text box as follows:

=IIf(Sum([YTD_Sales])=0,0,Sum([YTD_Sales]))

Thanks for your help!

 

[Duane Hookom]

If there are records in the section, you can try:
=Nz(Sum([YTD_Sales]),0)

 

[Emma Aumack]

Thank you Duane, I knew there was a better way....!
--
www.bardpv.com
Tempe, Arizona

If there are records in the section, you can try:
=Nz(Sum([YTD_Sales]),0)

--
Duane Hookom
Microsoft Access MVP

I have a report that totals in the section footer. Everything is fine if
there is a total. However, when the total is 0, nothing is displayed. I
would like it to display "0" as the total.

I am totalling in an unbound text box as follows:

=IIf(Sum([YTD_Sales])=0,0,Sum([YTD_Sales]))

Thanks for your help!