I have a #error in the below. FWIW In [txtBankName2] I have this: =[cboBankName_FAcility].[column](1) and it is a txt field with control name of txtBankName. I do have a similar Dsum and it works but in the one below I ahve changed the name of the qry. [Approved Amount In USD Equivalent] is currency.
=NZ(DSum("[Approved Amount In USD Equivalent]","qryLCIssued_Sum_Import-CSM_2","[Guarantor Description] = " & [txtBankName2]),0)