[AccessD] Feed variable to parameter query

Kaup, Chester Chester_Kaup at kindermorgan.com
Thu Jul 28 08:47:28 CDT 2005


Thanks. That got it.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike & Doris
Manning
Sent: Thursday, July 28, 2005 8:36 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Feed variable to parameter query

Try

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

    "FROM [tbl Schedules]" & _

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

Doris Manning
Database Administrator
Hargrove Inc.


-- 
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