Creating a Keyword Query

[Guest]

I creating a periodicals database, and I am attempting to write queries so
students can search the periodical titles by keyword. I have the query to
search the database for an title that matches an entry exactly: See below

SELECT Listings.ISSN, Listings.Locations, Listings.Subject, Listings.[Index
ID], Listings.Code, Listings.Title, Listings.[Alternate Title],
Listings.Holdings, Listings.Format, Listings.[Format Type], Listings.Use,
Listings.Frequency, Listings.Supplier, Listings.Cost, Listings.[Sub - Start],
Listings.[Sub - End], Listings.[Invoice Date], Listings.[Invoice #]
FROM Listings
WHERE (((Listings.Title)= [Enter Title:]));

however I can't seem to re-write this SQL statement so that I can search for
a keyword in the Listings.title field, when a keyword is entered into the
[Enter Title:] form.

If anyone could lighten me, I would be more than grateful

 

[PC Datasheet]

WHERE [Title] Like "*" & [Enter Keyword] & "*;"

 

[Guest]

I edited my query and I am still only recieving feeback for queries where the
title matches the keyword exactly, defeating the purpose of the Keyword
Search. I was hoping that all the user would have to enter was part of the
title.

See below what I have done:

SELECT Listings.ISSN, Listings.Locations, Listings.Subject, Listings.[Index
ID], Listings.Code, Listings.Title, Listings.[Alternate Title],
Listings.Holdings, Listings.Format, Listings.[Format Type], Listings.Use,
Listings.Frequency, Listings.Supplier, Listings.Cost, Listings.[Sub - Start],
Listings.[Sub - End], Listings.[Invoice Date], Listings.[Invoice #]
FROM Listings
WHERE Listings.Title LIKE "*" & [Enter Title:] & "*";

WHERE [Title] Like "*" & [Enter Keyword] & "*;"


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

I creating a periodicals database, and I am attempting to write queries so
students can search the periodical titles by keyword. I have the query to
search the database for an title that matches an entry exactly: See below

SELECT Listings.ISSN, Listings.Locations, Listings.Subject, Listings.[Index
ID], Listings.Code, Listings.Title, Listings.[Alternate Title],
Listings.Holdings, Listings.Format, Listings.[Format Type], Listings.Use,
Listings.Frequency, Listings.Supplier, Listings.Cost, Listings.[Sub - Start],
Listings.[Sub - End], Listings.[Invoice Date], Listings.[Invoice #]
FROM Listings
WHERE (((Listings.Title)= [Enter Title:]));

however I can't seem to re-write this SQL statement so that I can search for
a keyword in the Listings.title field, when a keyword is entered into the
[Enter Title:] form.

If anyone could lighten me, I would be more than grateful

 

[Guest]

I feel silly, I was able to get the query functioning after all, however I
was unable to get the results to show in the form that my other queries
display thier results.