Hale, Jim
Jim.Hale at FleetPride.com
Thu Aug 26 14:06:36 CDT 2004
I am currently doing the following to create a recordet from an existing parameter query: qryString(7) = "qryPlanHistCYplan_Upload_Improved" Set qdfTemp(7) = dbs2.QueryDefs(qryString(7)) qdfTemp(7).Parameters(strParameters(1)) = intDept qdfTemp(7).Parameters(strParameters(2)) = intCo qdfTemp(7).Parameters(strParameters(3)) = strCatcode1 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" I can't seem to get the syntax right. Can anyone tell me the correct syntax? TIA Jim Hale