sql help

[weltergon]

Am I doing something wron, its pulling everything up in the table vs. everything that the variable stItems is equal to:
strWhere = strWhere "(((tblWorkProductText.WorkProductName)='" & strItem & "'))"
my sql statement is a simple select * from table...
Thanks

 

[BSman]

Try removing all of the parentheses.

 

[weltergon]

That didn't work...I believe the parentheses are needed.
any other ideas?
Thanks

 

[TheAceMan1]

How are ya weltergon . . . . .

I see a missing concatenation operator . . . .

strWhere = strWhere "(((tblWorkProductText.WorkProductName)='" & strItem & "'))"

Should be

strWhere = strWhere & "(((tblWorkProductText.WorkProductName)='" & strItem & "'))"


TheAceMan