0

i am retrieving data from access using following command
"select * from sheet1 where [question number] like " & list(0) & " and [category] like " & list(1) & "and [sub-category] like " & list(2) & ""
now problem is if list(0)..... contains integer it works but if it is a string containing a,b then it donot work
plz help???

2
Contributors
1
Reply
2
Views
9 Years
Discussion Span
Last Post by binoj_daniel
0

it wont work for string as you missed the single quotes around the parameters.
So it should be like this: [question number] like '" & list(0) & "'

Let me know.. You can read more dev articles on coderewind.com

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.