Computer Science Homework Solutions
Problem
#132322

Query

Using the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached here

Why wont this query run?

SELECT authors.author_name
FROM authors
WHERE authors.author_name Like *twain*;

Attached file(s):
Attachments
WEEK1_Q1_Q2_ACCESS2000.mdb  View File
Solution
What is this?
By OTA - Overall OTA Rating
Ramesh Palipi, MSc (IP) - 4.7/5
Purchase Cost Now
$2.19 CAD (was ~$7.98)
Included in Download
  • Plain text response
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • Query in Access 2000 - You can use the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached to Lecture 1 if you want to play around with this query before answering: OK, I'm writing a query in Access 2000: ...
  • Why wont this query run? - OK, why wont this query run (using the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached here)? SELECT author_name FROM author WHERE author_name like "Twain, Mark";
  • Running a Query - Why wont this query run? SELECT authors.author_name FROM authors WHERE authors.author_name Like *twain*;
  • PQ#1 Why wont this query give me any results? - Why wont this query give me any results? SELECT author_name FROM authors WHERE author_name = "*Twain, Mark*"; After all, the text string Twain, Mark does exist in the ...
  • How would I have to modify this query to get it to run correctly? - 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) ...
Browse