dCOUNT HELP

[www]

I am using dCount in a text bot and I want a count of "Member" and "Added to membership" from my query.



=DCount("MailingID","q_Directive_track_NOVs","(Ord er_Response = ‘Member’ OR Order_Response = ‘Added to membership’)")

[June7]

Looks okay. What happens - error message, wrong result, nothing?

The inner pair of parens are not needed but should not hurt.

[ranman256]

=DCount("MailingID","q_Directive_track_NOVs","[Order_Response] = ‘Member’ OR [Order_Response] = ‘Added to membership’")

[www]

Thanks for the responses. I am still getting #Error in the text box though.

[www]

Got it to work:

=DCount("MailingID","q_Directive_track_NOVs","[Order_Response] = 'Member' OR [Order_Response] = 'Added to membership'")

Thanks for the help!!!

[June7]

Now I can see the original code has 'smart' single quotes. Did replacing them resolve? How did they get in there to begin with?