[AccessD] Correct syntax for parameter query

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





More information about the AccessD mailing list