[AccessD] SQL Syntax Problem

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 MartyConnelly
Sent: Thursday, August 03, 2006 3:41 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] SQL Syntax Problem

If you intended a wildcard

Like '" & PID* & "')) should be Like '" & PID & "*'))


Kaup, Chester wrote:

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

-- 
Marty Connelly
Victoria, B.C.
Canada

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com