I need to modify the below for I guess LEN on the LIKE portion of the Dsum.
I think I will need to look at the first 6 characters of [txtBankName2] instead of like * & txtBankName2 & *
=Nz(DSum("[SumOfApproved Amount In USD Equivalent]","qryLCIssued_
Guarantor Description] Like '*" & [txtBankName2] & "*'"
I think it would be best to post the db. It opens to the form. I need a Dsum per [txtBankName2]. I can not Dsum on the combobox because I am using a download of company data and bank names dont match so I need a like on the first few characters.
I supose LEN will look at only the first few characters and is the solution I am after but maybe there is a better solution if it is clear what I am after. You can see that the Dsum is returning $0 and this is not correct.
thank you for the help. Please ask if something is not clear.