I am getting the following error message:
In Operator without () in query expression '([companyCrewMember] In (46, 43) & [companyBillingDate] in (1).
It appears to be missing a ) but where when it's not in my statement. The code is:
StrWhere = Left(StrWhere, Len(StrWhere) - 2)
StrWhere = "[CompanyCrewMember] In (" & StrWhere & ") & [CompanyBillingDate] In (" & BillDt & ")"