J
Jack Sheet
Hi all
A report contains a box (terminology?) in the report footer that contains
the formula "=Count(*)"
This works fine with the exception that it returns the value #Error when
there are Null fields being counted.
How do I get it to return a value 0 in that situation?
Help files suggest some use of NZ() or ISNull() but I feel that an
equivalent of Excel's IsError() is more appropriate, since I cannot work out
how to get the alternatives to work :-(
Unfortunately, IsError() does not seem to be recognised in Access reports.
Thanks
A report contains a box (terminology?) in the report footer that contains
the formula "=Count(*)"
This works fine with the exception that it returns the value #Error when
there are Null fields being counted.
How do I get it to return a value 0 in that situation?
Help files suggest some use of NZ() or ISNull() but I feel that an
equivalent of Excel's IsError() is more appropriate, since I cannot work out
how to get the alternatives to work :-(
Unfortunately, IsError() does not seem to be recognised in Access reports.
Thanks