R
Rachel1
Guest
Hi,
I am having problems with count. I am trying to count the number of names on a report this works fine. However when there are no names to count on the report the count field returns
#Error.
I have tried using an IIF statement with no luck.
at the moment I have
=Count([Last Name])
I need to tell it something to display zero when there is nothing to count.
Cheers,
Rachel.
Follow Ups:
I am having problems with count. I am trying to count the number of names on a report this works fine. However when there are no names to count on the report the count field returns
#Error.
I have tried using an IIF statement with no luck.
at the moment I have
=Count([Last Name])
I need to tell it something to display zero when there is nothing to count.
Cheers,
Rachel.
Follow Ups: