Using IN in a parameter query 1

[Shairal]

There’s probably a real simple answer to this, but I just can’t figure it out. I have a basic query with a parameter prompting for office locations. I want the end user to be able to select either a single or multiple locations – I thought IN would work perfectly but I'm unable to get any results back using it.
I’ve tried
IN([enter location]), IN[(enter location)], IN[enter location], etc … none of these return data. Yet the simple [enter location] works every time.

Any assistance is greatly appreciated!

 

[Golom]

Unfortunately, entering something like

1,2,3,4 for [Enter Location]

with the statement

WHERE myField IN ([Enter Location])

results in the SQL

WHERE myField IN ("1,2,3,4")

i.e. it is attempting to match myField to the String and not to the comma-separated values in the string.

You might try

WHERE InStr(1,[Enter Locations] & ","), myField & ",") > 0

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]