hican anyone tell me, is it the IN operator can't be use/not supported in MS Access database?SELECT * FROM CustomersWHERE UserID IN ('1004','1005','1006')[Result]Data type mismatch in criteria expressionBTW, i am using ColdFusion and MS Access DB together.