Computer Science Homework Solutions
Problem
#132319

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:
  
        SELECT author_name
        FROM authors
        WHERE author_name like  "%Twain, Mark%";


    ... but it wont give me results. Why?

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 - 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*;
  • 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";
  • 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 ...
  • Rows from a Query - You can create your own Cartesian product - run this code in the database attached to Lecture Two: SELECT books.author_name, authors.author_name FROM books, authors; How many rows do you get a ...
  • Author and tittles - Using the week 2 lecture/homework database, show the author and titles of books that have never sold. Here is the SQL for my question, but what are the author and titles of the books that did not s ...
Browse