Microsoft Query - posted here as im not sure where is best!!

[hibster]

Hi Guys,

i am pulling info from a database into excel using Query. I want to use a list as a criteria.

EG

Criteria Field Name
Value =bob
0r =mark
=x
=y
=z

well i have a list of names in excel that i want to use to populate the bob, mark, x, y, z etc part.

Is it possible??

Kind regards

mark

 

[giacomo]

you need to use an IN statement, like this:

NAME in ("bob","mark","x","y","z")

hth,
Giacomo

 

[markyc]

You would need to set up a parameter query if your conditions are within Excel.