Avatar of pdvsa
Flag for United States of America

asked on 

Summing in a Report


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"))
Microsoft Access

Avatar of undefined
Last Comment
crystal (strive4peace) - Microsoft MVP, Access

8/22/2022 - Mon