Query Job id selection vis text box input

[justchillin]

Query Job id selection via text box input

I am trying to produce a query that will search for multiple records by job id entered into a text box eg 17656,18768,15679.

The example i have found uses the (LIKE '*value*') so if i type in part of a job id (176) it will display all records starting with 176. I would like to enter specific job id numbers seperated by a , and only display these

Would be grateful for any help

 

[llkhoutx]

Use

In(17656,18768,15679) as your criteria, even if you have to build it with VBA.

 

[justchillin]

Thanks for the tip