Link to home
Start Free TrialLog in
Avatar of pdvsa
pdvsaFlag for United States of America

asked on

Dsum and Like

Experts,

I am trying to modify the below Dsum to include a LIKE qualifier (check the bold)...I get a syntax.  

Let me know where I am wrong...thank you

=Nz(DSum("[SumOfApproved Amount In USD Equivalent]","qryLCIssued_Sum_Import-CSM_2","[Guarantor Description] = like &* '" & [txtBankName2] & "'" *& ),0)
Avatar of pdvsa
pdvsa
Flag of United States of America image

ASKER

here is an exploded view
(without the like qualifier)


untitled.JPG
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
you don't use "=" and "Like" together, you use only one , "=" or "Like"


=Nz(DSum("[SumOfApproved Amount In USD Equivalent]","qryLCIssued_Sum_Import-CSM_2","[Guarantor Description]  like & '*" & [txtBankName2] & "*'"),0)
Avatar of pdvsa

ASKER

ok that was it.   I will have to ask another question because I think I need a Len I suppose.  The like statement is returning 0 Dsum.
Avatar of Norie
Norie

What is it you are trying to check for?

If you tell us that it might simplify the whole thing.