We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Solved
subform value
Posted on 2012-12-20
I have a report called Charges_Rpt that contain two subreports
SRpt_supplies
Srpt_services
each one of the subreport has total charges.
total_supplies
total_services
what I have the charges_rpt is a filed of grand total from both subreport. it works good when I have value in both sub reports but when one of them has blank data, the subreport does not show but the sum in the charge report would give me error
Grand_Total
SRpt_supplies
Srpt_services
each one of the subreport has total charges.
total_supplies
total_services
what I have the charges_rpt is a filed of grand total from both subreport. it works good when I have value in both sub reports but when one of them has blank data, the subreport does not show but the sum in the charge report would give me error
Grand_Total
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
4 Comments
Active today
Use the NZ function in whatever field could have a null value. For example:
Nz([Amount],0)
The above will return a zero whenver a field has no value.
Nz([Amount],0)
The above will return a zero whenver a field has no value.
Depending on your report design, (Grouped Report with GT in the group footer)
You can also use IsError() for the missing (no sum) subreport
The syntax can get a little intimidating, but it basically says if the subreport contains no data, it may not display, If that is the case, it is not null, it just does not exist, and #Error is returned for any math operation concerning the missing value .
So wrapping it in IsError, you can force it to return Zero
=IIF(IsError([Something]),
Sample attached, see rptEmployees
JimD also has another technique using a Function:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26786795.html
JeffCoachman
Access-EEQ-27974958SubFormSubRep.mdb
You can also use IsError() for the missing (no sum) subreport
The syntax can get a little intimidating, but it basically says if the subreport contains no data, it may not display, If that is the case, it is not null, it just does not exist, and #Error is returned for any math operation concerning the missing value .
So wrapping it in IsError, you can force it to return Zero
=IIF(IsError([Something]),
Sample attached, see rptEmployees
JimD also has another technique using a Function:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26786795.html
JeffCoachman
Access-EEQ-27974958SubFormSubRep.mdb
Hi all,
=NZ([Temp_Radiology subreport].[Report]![Grand
it worked only in a layout view, when I run it to report preview or print. it shows error.
Any help or suggestions.
=NZ([Temp_Radiology subreport].[Report]
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
AutoNumbers should increment automatically, without duplicates. But sometimes something goes wrong, and the next AutoNumber value is a duplicate. This article shows how to recover from this problem.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Learn how to number pages in an Access report over each group.
Activate two pass printing by referencing the pages property:
Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses
Course of the Month6 days, left to enroll
688 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.