How to create a parameter query with multiple values

[pjtessi9]

Hi, I want to create a query that will prompted me with the choice of data to enter separated by a comma. (parameter prompt that accepts multiple values)

Exemple: Prompt box opens, I type 11444,1443,14455 and then the query shows the results for these 3 inputs only... Sometimes I have to input 2 numbers, 4 numbers, etc...it's never the same amout.
I want the values type to be separated by a comma.

I tryied this examble below using the INSTR function but Access is saying that the syntax is not valid

InStr([Enter number separated by commas],[Numbers])>"0"

I am using Access 365



Any ideas would be appreciated
Thanks!

[Micron]

I don't think that function makes sense for this. Perhaps your sql should use IN operator because of your cs values. However, I think you'll have to do this in code because each value would have to be delimited with single quotes, unless maybe you're willing to type those around every value you enter. If you try to do it in a stored query, you'll need a form that has a control containing the cs values, but again, everything needs to be delimited one way or the other - by your typing, or by code.

[Gicu]

Can you show us the a screen shot of your data and of the query (in design view) where you try to implement this?

Cheers,

[pjtessi9]

Here is the screenshot requested...thanks for your help

[Micron]

This has been asked and answered many times - there are even videos for it. Here's just one

https://thedbguy.blogspot.com/2018/1...to-accept.html

[CJ_London]

There is one way if using IN in this sort of scenario - using the eval function

SELECT *
FROM myTable
WHERE Eval([myfield] & " IN (" & [enter values separated by comma] & ")")

note the query view of this will add =true or <>false

But as per the link provided by Micron, no validation although a space after a comma will still work (it wouldn't if using instr unless you also use the replace function to remove them)

The other issue is if used to search for string values then the user needs to type for example, 'abc','def'

As others have said, using parameters in this way is not a good way to go, better to use a form so the search criteria can be validated before being applied