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???
virus220 0 Newbie Poster
binoj_daniel 14 Practically a Master Poster
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
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.