printing count of records

[sheela]

Hi,
I have a report based on query. In the header section I am
printing the count of records in the report. For that I am
using countof(autonumberfield) in the query.
If the count is >0 , this works okay. But if there are no
records in the report, then the count is being prited
as: "#Error". How do i print this as 0?
Is there another way to print the count of records in a
report?

TIA.
Sheela.

 

[Duane Hookom]

Use:
=IIf([HasData], Count([AutoNumberField]), 0)