Hello!
I managed to show the data from the sub report on the main report. But the problem is that if sub report column I would like to use in calculation in main form is empty, I get an "#error" in my textbox. Now I tried nz, isnull, and combinations of the two that can be found in Access help but to no avail.
How can I replace that "#error" with "0" so that it doesn't propagate to the rest of my calculations?
Thanks!
I managed to show the data from the sub report on the main report. But the problem is that if sub report column I would like to use in calculation in main form is empty, I get an "#error" in my textbox. Now I tried nz, isnull, and combinations of the two that can be found in Access help but to no avail.
How can I replace that "#error" with "0" so that it doesn't propagate to the rest of my calculations?
Thanks!