[AccessD] SQL Syntax Problem

Kaup, Chester Chester_Kaup at kindermorgan.com
Thu Aug 3 15:58:24 CDT 2006


Tried your change but when I do a debug print of the problem area of the
query I get And ((ConfigMaster.PID) Like '*'))

What I need it to say is And ((ConfigMaster.PID) Like 'PID*'))

Thanks.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
DWUTKA at marlow.com
Sent: Thursday, August 03, 2006 3:52 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] SQL Syntax Problem

Like '" & PID & "*'))

Also, keep in mind, if you are using ADO, the * should be a %.

Drew

-----Original Message-----
From: Kaup, Chester [mailto:Chester_Kaup at kindermorgan.com] 
Sent: Thursday, August 03, 2006 3:05 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] SQL Syntax Problem

The following SQL gives a syntax error of compile error expected
expression when it gets to the & in this part   And ((ConfigMaster.PID)
Like '" & PID* & "')). I don't see the problem. PID is text.

 

strSQL = "SELECT ConfigMaster.PID, Count(ConfigMaster.PID) AS CountOfPID
INTO [tbl Pattern Occurances] " & _

             "FROM [tbl Producers in a Scaleup Pattern] " & _

             "INNER JOIN ConfigMaster ON [tbl Producers in a Scaleup
Pattern].ChildPID = ConfigMaster.ChildPID " & _

             "WHERE ((([tbl Producers in a Scaleup Pattern].PID)= '" &
PatternName & "' And ((ConfigMaster.PID) Like '" & PID* & "')) " & _

             "GROUP BY ConfigMaster.PID;"

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.

 

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