CAPETOWNANDRE
New member
- Local time
- Today, 03:25
- Joined
- Aug 9, 2009
- Messages
- 2
I am using vba to call queries, but I cannot get to pass in a list of elements into the parameter.
how do you seperate the diffrent elements
I hav a Text parameter MYparm
I have a query which reads
/code
select * from mytable
where myvalue in ([myparm]);
/*
if I enter a single value into the parm it works ok
But I cannot enter more than one value
I need to be able to enter value1,value2,value3
how do you seperate the diffrent elements
I hav a Text parameter MYparm
I have a query which reads
/code
select * from mytable
where myvalue in ([myparm]);
/*
if I enter a single value into the parm it works ok
But I cannot enter more than one value
I need to be able to enter value1,value2,value3