Getting rid of #Error in control

[PaulA]

I am trying to rid the #Error that appears when generating a report. It appears in a control which has a count function expression when there are no records to count. I want the control to show a "0" instead of the #Error.

Not successful so far.

Any ideas?

Thanks.

 

[christheancient]

Have a look at my thread a bit further down.

Chris

 

[Matt Rayne]

You can use a null statement

IIF(IsNull([Field Name], "0", count([Field Name])

If I understand what you need right, this should help