ODBC SQL - using a string for a parameter

[djwbaker]

Hi

been using ODBC SQL queries for 12months plus, not a huge user of VBA.
I am wondering when using a parameter query can I create a string for multiple criteria

currently I can use a single criteria

customer = ? [and link it to a parameter in cell a1]

but anyone know a way I can do

customer in (?) [and link it a cell that contains several accounts?]

many thanks
Dan

 

[VBA Geek]

do you have a stored procedure in your database?

otherwise just it within an SQL

SELECT * FROM MYTABLE WHERE MYTABLE.CustomerID IN ('1001','1004','1005','1006')

'1001','1004','1005','1006' would come from your range A1

 

[djwbaker]

I can make the criteria a parameter eg customer = ? or customer =(?)
but if I can not format text to create a string value that is excepted

'jon smith','joe blogs' or (jon smith','joe blogs') in a cell linked as a parameter[TABLE="width: 72"]

<colgroup><col width="72" style="width: 54pt;"></colgroup>
<tbody>[TR]


[TD="class: xl63, width: 72, bgcolor: transparent"][/TD]


[/TR]

</tbody>[/TABLE]