IN Operator

[liewsin]

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.

[aspnetguy]

I just ran the following query on my Access DB with no problems

SELECT *FROM RelatedPagesWHERE Label IN ('IBM','Spatter');

Is UserID a number or is it of the type text??If it is a number then try this

SELECT * FROM CustomersWHERE UserID IN (1004,1005,1006)

[liewsin]

Thx mate! it works! LOL

I just ran the following query on my Access DB with no problems

SELECT *FROM RelatedPagesWHERE Label IN ('IBM','Spatter');

Is UserID a number or is it of the type text??If it is a number then try this

SELECT * FROM CustomersWHERE UserID IN (1004,1005,1006)

<{POST_SNAPBACK}>

[aspnetguy]

no problem, glad i could help