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?