Forum Discussion
Solved
Dcount Multiple Criteria
Hello Experts, I am trying to add an additional criteria but I am not getting the result I expect. I am not getting any error messages but it returns "yes" for each record and that is not correct ...
- InFBL1NInvStrip: IIf(DCount("*","Import_Excel_FBL1N","[Invoice No Stripped] ='" & [Invoice No Stripped] & "' And [Amount in doc curr] = " & [Invoice amount])>0,"Yes","No")
InFBL1NInvStrip: IIf(DCount("*","Import_Excel_FBL1N","[Invoice No Stripped] ='" & [Invoice No Stripped] & "' And [Amount in doc curr] = " & [Invoice amount])>0,"Yes","No")
Perfect. I see where the issue is.
"[Invoice No Stripped] ='" & [Invoice No Stripped] & "'"
should be:
"[Invoice No Stripped] ='" & [Invoice No Stripped] & "'
very tricky. thank you. It works great!
"[Invoice No Stripped] ='" & [Invoice No Stripped] & "'"
should be:
"[Invoice No Stripped] ='" & [Invoice No Stripped] & "'
very tricky. thank you. It works great!