Originally posted by r937
for your first problem, ORDER BY must follow WHERE
for your second problem the string delimiter is the single quote, not the double quote
Thank you, first problem solved (Order of operations did the trick)
However, the second problem remains:
rs.Open "SELECT main.title, main.url, main.description, main.city
WHERE (((main.category_2)='elem'));", conn%>
When you said the string delimiter is the single quote, I am assuming that means to bracket the elem by single quotes instead of double. The above select statement still gives me a Unterminated string constant error.