SQL statement

[weltergon]

HI,
If strItems= "conceptual"
what is worng with the following code? its not recognizing the where statement...
strWorkProductsSQL = strItems2
strFullSQL = "SELECT * FROM tblWorkProductText WHERE (((tblWorkProductText.WorkProductName)=" & strWorkProductsSQL & &quot);"

 

[TonyJollans]

Hi weltergon,

If I had a penny for every missing or misplaced quote ...

Assuming strWorkProductsSQL is a string, try ..

strFullSQL = "SELECT * FROM tblWorkProductText WHERE (((tblWorkProductText.WorkProductName)='" & strWorkProductsSQL & "'));"

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.