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
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
Try:
Count = DCount("Reference", "tblLog", "IncidentReportStatus = 'Requested' OR IncidentReportStatus ='Returned'")
YEP!!!
Thats the one
Count = DCount("Reference", "tblLog", "[IncidentReportStatus] = 'Requested' OR [IncidentReportStatus] ='Returned'")
I also wrapped the Field in [] to be sure.
Thanks