[AccessD] Feed variable to parameter query

Mike & Doris Manning mikedorism at verizon.net
Thu Jul 28 08:35:37 CDT 2005


Try

    strSQL = "SELECT Pattern, [CO2 Injection Start Date Schedule1]" & _

    "FROM [tbl Schedules]" & _

    "WHERE [tbl Schedules].Pattern= '" & PatternName & "';"

Doris Manning
Database Administrator
Hargrove Inc.





More information about the AccessD mailing list