MS Access 2013: I have a subform with some calculated fields in the detail. I want to summarize these fields in the footer of the report but the summary fields in the footer of the report show '#error'.
This is one of the calculated fields in the Form 'Detail' section, Name:'AccumPayAmt', Control Source: '=IIf([PostedStatusID]=3,0,[PayAmt])'
The calculated fields are showing the correct amount.
This is one of the summary fields in the form 'Footer' section: Name 'Text108', Control Source: '=Sum([AccumPayAmt])'
There are a few other fields but all are the same construct.
Can anyone spot the problem?