DLOOKUP with more then one variables..

I am having some trouble with a DLOOKUP statement
Basically I am trying to count the records where ID is equal to a number and the domain_verified field is equal to yes
I am just having some problems with the AND clause..and the quotes

the ID and healthcheck.ID is a number
[Domain_Verified] is a text field

xxyes = DCount("[Domain_Verified]", "tbl_org_domains", "[ID] = " & healthcheck.ID And "[Domain_Verified] = 'Yes'")

Who is Participating?
Patrick MatthewsCommented:
xxyes = DCount("[Domain_Verified]", "tbl_org_domains", "[ID] = " & healthcheck.ID & " And [Domain_Verified] = 'Yes'")
joein610Author Commented:
Awesome thanks Again!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.