I have a couple of sub-reports that occasionally contain no records, so when Access tries to do a calculation in the master report, I get an #Error message. So this may sound like a dumb question, but is there a way to do an if statement where if the calculation results in an #Error, it will replace it with a “”0” (zero). If that can’t be done, how do I get a phantom record to show up in the query, so the report calculations don’t come up as #Error. And no, default values don’t do me any good since there isn’t a record to apply the default values to.
I
