Manual Entry of Criteria

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I want a query to search for information based on my
entry:

SELECT * FROM Mytable
WHERE Id IN ([Enter Id #'s]);

If I try and enter multiple Id's separated by commas, the
query returns no values.

The Id's are not necessarily sequential.

Thanks,

dk
 
Hi,


SELECT *
FROM myTable
WHERE ( ',' & [Enter ID #'s] & ',') LIKE ( '*,' & id & ',*' )


The Id should be entered without space, like 2,3,55
not: 2, 3, 55




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top