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
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
