Where criteria using "OR"

[craig1988]

Count = DCount("Reference", "tblLog", "IncidentReportStatus = 'Requested' OR 'Returned'")

Hi

How do I use "OR" in the criteria above. I presume one or more of my "'s are incorrect.



Thanks

[cyanidem]

Try:
Count = DCount("Reference", "tblLog", "IncidentReportStatus = 'Requested' OR IncidentReportStatus ='Returned'")

[craig1988]

YEP!!!

Thats the one

Count = DCount("Reference", "tblLog", "[IncidentReportStatus] = 'Requested' OR [IncidentReportStatus] ='Returned'")

I also wrapped the Field in [] to be sure.

Thanks