Query Problems

[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

 

[Allen Browne]

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;

 

[Roshawn Dawson]

Thanks Allen. That helped a lot!!!