code help...

  • Thread starter Thread starter accessdenied
  • Start date Start date
A

accessdenied

I'm trying to add some code to check against my table.. and i'm gettin
"expected end of statement" errors..

can someone help.. thanks

sqlString = "SELECT Count(tblInspections.FLT) AS CountOfFLT
Left([FLT],2) AS FaultType FROM tblInspections INNER JOIN tblQR O
(tblInspections.strReference = tblQR.strReference) AN
(tblInspections.strArea = tblQR.strArea) AND (tblInspections.strProjec
= tblQR.strProject) WHERE tblInspections.FLT Is Not Null " & sqlStrin
& " GROUP BY Left([FLT],2);"

I tried :

sqlString = "SELECT Count(tblInspections.FLT) AS CountOfFLT
Left([FLT],2) AS FaultType FROM tblInspections INNER JOIN tblQR O
(tblInspections.strReference = tblQR.strReference) AN
(tblInspections.strArea = tblQR.strArea) AND (tblInspections.strProjec
= tblQR.strProject) WHERE tblInspections.FLT Is Not Null AN
*tblInspections.FLT)<>" "*" & sqlString & " GROUP BY Left([FLT],2);"

But that doesnt work...


thank
 
Hi,


Your variable sqlString is concatenated with itself... what does it
contain... or more likely what is the resulting string you tried to execute,
exactly?



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top