I need to sum tblPayments.Amount in the below. How can I do this? I have tried to put the word SUM in many places.
This is a field in a report.
I can not drag in tblPayments to the query so I need the Dlookup.
=IIf([PaidInFullYN]=True,"Paid In Full",Format(Nz(DLookUp("[Amount]","tblPayments","[LCID] = " & [LetterOfCreditID]),0),"Currency"))