Query - [Enter Number] but more than one number?

[papasmurfuo9]

Hi

i have a query with an inputbox for numbers

[Enter Number]

if i want the query to return multiple numbers how would i do this?
so the user could have 3 5 and 8 to search for, currently the [enter number] allows them to search for one at a time

thanks

 

[namliam]

Not use a parameter but use a form to allow the user to enter the data they require

Then use some VBA to splice the search into the sql before opening the query/form/report