Let's say my author name column in the table "authors" (in the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached here) was named:
author name (not author_name, as it is currently named)
This is OK to do (to use "whitespace" in a column or table name), but how would I have to modify this query to get it to run correctly?
SELECT authors.author name
FROM authors
WHERE authors.author name Like "*twain*";