When using Dsum, it is necessary to include the same conditions in the query qryLCIssued_Sum_Import-CSM
_2? It seems as though I do. I ask this because within the qry I already have the condition of [Actual Status]<>"GEC" but Dsum seems to ignore this condtion within the qry which means I have to reference the same condition in Dsum?
=Nz(DSum("[SumOfApproved Amount In USD Equivalent]","qryLCIssued_
Guarantor Description] Like '*" & Left([txtBankName2],6) & "*'"),0) And [Actual Status]<>"GEC"
oh and btw the condition syntax is not correct at least I dont think it is because I get a #name and have a question out here: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27422785.html