[AccessD] Correct syntax for parameter query

Thanks, but no joy. I think what I am attempting to do is not possible. The
workaround is to reopen the recordset for each change in the parameter.
Thanks anyway
Jim Hale

-----Original Message-----
From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg]
Sent: Thursday, August 26, 2004 5:21 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Correct syntax for parameter query


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


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com