Return a Zero if no Records Match

[kenneth2k1]

Hello guys!

I had a simple question that I'm sure someone can answer. I have one field that does this calculation:

Count(Agnt_to_Prosp::ActnList) + Count(Agnt_to_Prosp::ApptResList). The calc works fine, however when no field values can be added (0 + 0), the field is blank.

I have another calc field that looks like this:

((IsEmpty(Agnt_to_Prosp::ActnList)) and (not IsEmpty(Agnt_to_Prosp::Letters4)) and (not IsEmpty(Agnt_to_Prosp::Date_Ltr4)) and (Status(CurrentDate) >= Agnt_to_Prosp::Date_Ltr4 + 4)). This one works fine also, but when nothing qualifies it returns a "0."

Is there a quick way to have the first calc return a 0 (if 0+0) using the Count( ) step? (Yes, I did go to Number Format).

Thanks all

Ken

[Vaughan]

Uncheck the option (in the field definition) that says "do not calculate if all fields are empty" or similar.

[kenneth2k1]

Thanks for the help as always.

Ken