Stuart McLachlan
stuart at lexacorp.com.pg
Thu Aug 26 17:21:25 CDT 2004
On 26 Aug 2004 at 14:06, Hale, Jim wrote: > qdfTemp(7).Parameters(strParameters(4)) = "sales" > qdfTemp(7).Parameters(strParameters(5)) = strPlGroup > > Set recset(7) = qdfTemp(7).OpenRecordset() > > This works fine. However, I need to change parameter(4) into something like > the following > qdfTemp(7).Parameters(strParameters(4)) = "sales or misc" Try "'sales' or 'query'" ie put the individual items in single quotes.-- Stuart