Count field

[eshaan]

I have feild that counts. When data is not available it is printing Error. How Can i print 0 instead of Error.

Please help me.

Thanks.

 

[THWatson]

eshaan
You say "when data is not available." Is this data from a subreport? If so, you have to check for data using the HasData property.

Tom

 

[mordja]

eshaan,

Instead of using count you could set the control source of the counting field to

=Sum(IIf(IsNull([YourField]),0,1))

Where [YourField] is the field you want to count.

Mordja