pdvsa
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)
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_
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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)
=Nz(DSum("[SumOfApproved Amount In USD Equivalent]","qryLCIssued_
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.
What is it you are trying to check for?
If you tell us that it might simplify the whole thing.
If you tell us that it might simplify the whole thing.
ASKER
(without the like qualifier)
untitled.JPG