Discussion Locked
No record meets a criteria creating an error in a calculation
0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I creating a report showing the different types of private sewage systems installed during a time period. If a specific type was no installed I get a blank field in the subreport. When I attempt to include that blank field in a calculation I get ERR# result.
IS there away around this. I have tried Nz expression with no success.
Please advise.