Trapping for EOF in Control Source

[drblanston]

I currently have a subform that has a sum() text field which sums up all the payments of the records listed. The control source of that text field looks like this:



=Sum([pymt_Amount])

Its a pretty simple calculated field.

However, I need to trap for End of File (EOF). In other words, if there are no records, I want this field to be 0 (zero).

Is there a way to put an IIF statement that says something like =IIF (EOF syntax, 0, Sum([pymt_Amount]))

The EOF syntax is what I am looking for.

any clues?

[June7]

Don't think can detect EOF in ControlSource expression.

Try:

=Nz(Sum([pymt_Amount]),0)

or

=IIf(Count(*)=0, 0, Sum([pymt_Amount]))

[Missinglinq]

All you need to do is to change

=Sum([pymt_Amount])

to

=Nz(Sum([pymt_Amount]),0)

Linq ;0)>

[Missinglinq]

Ouch! Didn't bump you too hard at the finish line, did I, June?

[drblanston]

Gracias.... the Nz(Sum([pymt_Amount]),0) works well... Puts the Zero in the field. Thanks again

[Missinglinq]

Glad we could help!

Good luck with your project!

Linq ;0)>