Experts,
I am trying to combine the below in an unbound field on a report.
Maybe its better to do it by VBA?
Not sure which way is easier.
thank you...
In English:
If tblLetterOfCredit.PaidInFullYN = True then "Paid In Full", if not then Dsum but only if tblPayments.PaymentDate is not null (meaning there is a date entered)
--------------------------------------
If tblLetterOfCredit.PaidInFullYN = True then "Paid in Full"
Else:
If is not null [PaymentDate] then Dsum [Amount]. How to add Is Not Nulll to below?
=iif(DLookUp("[PaymentDate]","tblPayments","[LCID] = " & [LetterOfCreditID]
dsum("[Amount]","tblPayments","[LCID] = " & [LetterOfCreditID]
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.