DCOUNT function with IN statement

[dwilson]

DCOUNT with IN Statement
I have a report where I use numerous DCOUNT functions, and it works fine. But now I need another report which has multiple conditions, and I can't seem to find examples anywhere to get my syntax right. For this example, the field 1 ENJOY in table CONGSITEALL needs to pull out the number of entries for the answer Yes, Definitely, and Most of the Time. I have tried putting the quotes, etc into diffeent places but I just can't seem to find the right combination.

=DCount("[1 ENJOY]","CONGSITEALL","[1 ENJOY] IN ('''Yes, Definitely','Most Of The Time'")

Once I get an answer I will document this so I will know how to do it in the future.

[boblarson]

=DCount("[1 ENJOY]","CONGSITEALL","[1 ENJOY] IN ('Yes', 'Definitely','Most Of The Time')")

[dwilson]

That's it! Thank you so much!!