Query Problems

  • Thread starter Thread starter Roshawn Dawson
  • Start date Start date
R

Roshawn Dawson

Hi,

I have a table in an Access database that contains nearly 2500 rows. I
am trying to locate rows by the keywords field in the table. My query
looks like this:

SELECT TOP 10 Books.ISBN, Books.Title
FROM Books
WHERE Books.Keywords = [Enter a keyword to search]
ORDER BY Books.Title DESC;

For reasons unknown to me, this query doesn't work at all. No rows are
returned. Can someone tell what I'm doing wrong?

Thanks
Roshawn
 
Does the Keywords field contains multiple keywords?

If so, you will need:

SELECT TOP 10 Books.ISBN, Books.Title
FROM Books
WHERE Books.Keywords Like "*" & [Enter a keyword to search] & "*"
ORDER BY Books.Title DESC;
 
Back
Top