[AccessD] Correct syntax for parameter query

Jim Hewson JHewson at karta.com
Fri Aug 27 11:16:18 CDT 2004


Have you tried:
qdfTemp(7).Parameters(strParameters(4)) = "sales" OR "misc"

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Hale, Jim
Sent: Friday, August 27, 2004 10:54 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [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
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list