I am creating a financial report in Access 2007. My report has a subreport. I am trying to pull subtotals from the subreport. Some of my fields from the subreport do not have any data, so I am receiving an #error in the text box. I need a code to turn the #error into 0. I currently have the following code in the text box =[Donations].[Report]![txtTotalsDonation Amount]
I have attached two screenshots of what I am doing.
Please help me get rid of #error and replace it with 0
I have attached two screenshots of what I am doing.
Please help me get rid of #error and replace it with 0