[AccessD] Correct syntax for parameter query

Thanks Gustav
Jim Hale

-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk]
Sent: Friday, August 27, 2004 11:36 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Correct syntax for parameter query


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

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