Designing a query for "keywords"

[Mike Webb]

[I am very new to Access.]

I want to design a query to return scanned newspaper articles based on
assigned keywords. I put a field in my table with a look-up list of 8
keywords. Each article can have 1 or more keywords assigned.
Can't figure out how to do it.
I have a book called "Office XP: The Complete Reference" from Osborne/McGraw
Hill. Helpful, but I can't find an example of this. Looked at Access Help,
but couldn't find what I needed.
My goal is to have a form for users to ask the database "List all records
with keywords AAA, BBB, and CCC", for example. After I get this licked I
want to add date ranges to look for articles with certain keywords (or just
all articles within the dates specified).
Can someone point me in the right direction?

Thanks in advance,
Mike

 

[Kevin]

My goal is to have a form for users to ask the
database "List all records with keywords AAA, BBB, and
CCC", for example. After I get this licked I want to add
date ranges to look for articles with certain keywords (or
just all articles within the dates specified).

Can someone point me in the right direction?
....
Mike,

My approach would be to create an unbound form with a
number of combo boxes based on your table of keywords.
The user may enter as many keywords as combo boxes that
you provide.

Place a command button on the form. Code for the OnClick
event should 1) assemble an SQL WHERE clause based on the
user's entered keywords and 2) open a form using this
clause as the filter criteria.

Search your book and the Visual Basic help on the OpenForm
action and WHERE clause; that should get you there.

HTH
Kevin Sprinkel
Becker & Frondorf