My response was with respect to multiple parameters generally--Not specific to the IN operator.
However:
These parameter queries work in my testing.
1:
Code:
PARAMETERS P1 Text ( 255 ), P2 Text ( 255 );
SELECT animal.[AName], *
FROM animal
WHERE Left(animal.[AName],1 ) In ([P1],[P2]);
2:
Code:
PARAMETERS P1 Text ( 255 ), P2 Text ( 255 );
SELECT animal.[AName], *
FROM animal
WHERE (((animal.[AName]) In ([P1],[P2])));
Result of 1: with the attached table, using P1 = J, P2 = S
AName |
AnimalId |
Spot |
1 |
Jim |
2 |
Sam |
3 |
Johnny |
7 |