asked on
subform value
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
Microsoft Access
Last Comment
Jeffrey Coachman
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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]![Grand
it worked only in a layout view, when I run it to report preview or print. it shows error.
Any help or suggestions.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Nz([Amount],0)
The above will return a zero whenver a field has no value.