I am attempting to do a Dlookup. I have a syntax. I think the issue is somewhere around the "179" part but I dont really know.
If the Guarantor Description is like "DNB*" then I need to lookup the FacilityAmount in tblBankFacilityAmts then subtract the SUM [Approved Amount In USD Equivalent]
The [Approved Amount In USD Equivalent] is a field in the query. circled in the pic.
here it is:
Available: iif("[Guarantor Description]" like "DNB*", Dlookup("[FacilityAmount]"
s", "[BankName_Facility] =" 179 – Sum([Approved Amount In USD Equivalent],0)