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
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.