[AccessD] Correct syntax for parameter query

Gustav Brock gustav at cactus.dk
Fri Aug 27 11:35:59 CDT 2004


Hi Jim

If you meant that the parameter value could be either "sales" or
"misc", you are right. You need two parameters to do that - and it
wouldn't look nice. Your solution is what I would choose.

/gustav


> 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




More information about the AccessD mailing list