How would I have to modify this query to get it to run correctly?
Not what you're looking for?
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*";
Purchase this Solution
Solution Summary
The expert determines how to modify a query to get it to run correctly.
Purchase this Solution
Free BrainMass Quizzes
Basic Networking Questions
This quiz consists of some basic networking questions.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
C# variables and classes
This quiz contains questions about C# classes and variables.