Sub Reports with No Data

danielw.au

Registered User.
Local time
Today, 22:19
Joined
Mar 12, 2014
Messages
10
Hi Everyone,

I have a report called LRPT_PaymentProcessing_Std. This report has a number of sub reports within it, for example, LRPT_PaymentProcessing_Detail_Std_HoursLeave.

The LRPT_PaymentProcessing_Detail_Std_HoursLeave sub report contains a total, AccessTotalsPP_Det_AValue.

In my main report, I have a text box that uses the AccessTotalsPP_Det_AValue total from the sub report. I do this using the following expression:

=[LQRY_PaymentProcessing_Detail_HoursLeave].[Report]![AccessTotalsPP_Det_AValue]

I'm running into an issue if there is no data in one of the sub reports. When this occurs, I get #Type!.

Is there a way for me to test for null records and then if there are no, execute my expression?

I have attached an example. Note, the Payment section containts a number of sub reports based on payment type.

I'm not an expert with Access and appreciate any assistance to resolve this issue.

Daniel :)
 

Attachments

  • Sub Reort Issue.PNG
    Sub Reort Issue.PNG
    19.2 KB · Views: 105
Thanks Paul. As Im not an expert with access, I'm not exactly sure how to use this code.
 
Copy the function into a standard module and change your formula to:

=nnz([LQRY_PaymentProcessing_Detail_HoursLeave].[Report]![AccessTotalsPP_Det_AValue])
 

Users who are viewing this thread

Back
Top Bottom