Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

When one row zero, subreport does not show?

Status
Not open for further replies.
MaddiMond

MaddiMond

Technical User
Mar 28, 2005
76
US
I have a subreport with monthly amounts and also a running sum over these monthly amounts. For some people this amount is 0 for a month, so the report should still be displayed, but it does not show....How can I enable the report to show the zero amounts and have it zero or adding zero where necessary??

Maddi
 
Sort by date Sort by votes
in your control, use NZ(fldName, 0)

--------------------
Procrastinate Now!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Show Previous Year 1
Replies
5
Views
422
dhookom
dhookom
lameid
  • Locked
  • Question
Docmd.OutputTo Not Exporting Subreport
Replies
2
Views
303
lameid
lameid
TrekBiker
  • Locked
  • Question
Labels not aligned when Can Grow/Shrink enabled 1
Replies
7
Views
263
TrekBiker
TrekBiker
breezett93
  • Locked
  • Question
Sending report via email only works when Outlook is closed
Replies
1
Views
394
breezett93
breezett93
breezett93
  • Locked
  • Question
What should be multiple reports is becoming one report with multiple pages 1
Replies
13
Views
364
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top