DCOUNT function in report with IN statement

[cicoa]

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.

 

[PHV]

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

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cicoa]

Thank you, that's it!