code help...

[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

 

[Michel Walsh]

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