Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Dec 19, 2022

DCount

Hello Experts,   I am wanting to check if a table [Import_Excel_FBL1N] has a match on [InvNo].  I am not sure if Dcount is the best way to do this?      Import_Excel_FBL1N.Reference = TEXT InvNo...
access
  • Tom_van_Stiphout's avatar
    Tom_van_Stiphout
    Dec 19, 2022
    If InvNo is text, you need to wrap it in single-quotes:
    =IIf(DCount("*","Import_Excel_FBL1N","[Reference] ='" & [InvNo] & "'")>0,"Yes","No")
Tom_van_Stiphout's avatar
Tom_van_Stiphout
Steel Contributor
Dec 19, 2022
If InvNo is text, you need to wrap it in single-quotes:
=IIf(DCount("*","Import_Excel_FBL1N","[Reference] ='" & [InvNo] & "'")>0,"Yes","No")
  • Tony2021's avatar
    Tony2021
    Steel Contributor
    Dec 19, 2022
    ahh yes. the text quotes. I forget about this too often. thank you. It works now.

Resources