Report Sum

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

Guest

I have a text box that calculates a sum. When the sum is zero nothing
populates the text box. I would like a zero to populate the text box. How
would I do that?
 
Don't know how "a text box that calculates a sum" is created. You might be
able to use
=Nz(Sum([YourNumericField]),0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing in a Report Footer 7
Is there a better way? 4
# Error when no data 4
Sum a field with null value 5
Report Totals on Text Boxes in Sub Report 2
Calculate Subreport totals in a main report Group footer 3
Sums based on textbox calculates 5
Access 2003 Running Sum Question 8

Back
Top