Overcoming #Error (Access 97)

[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

 

[Jack Sheet]

Typo
For "Null fields being counted" read "Null records being counted"