[AccessD] SQL Syntax Problem

You seem to suggest that all your PIDs start with the prefix "PID".  If
that is so, then just put the literals into the SQL Statement at that
point:

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

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Thursday, August 03, 2006 1:55 PM
To: Access Developers discussion and problem solving
Subject: Re: [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.