G
Guest
I have a database of our technical library holdings that includes a table of
books--title, author, etc.--and a table of keywords connected by the common
key "Book ID". These come together in a parameter query in which the
parameter value is "keyword". The "keywords" field usually includes several
keywords, separated by commas. If I just run the query as is, I get a
report, but the records include only those books with keyword fields
containing that one keyword and no others; I don't get the other books where
that keyword is one of several. For example, if I answer the parameter query
with the word "pavement", my report shows four books; there are fifteen books
that contain the word pavement in the keyword field.
I think I need a filter that will select those records that contain the
keyword. I know nothing about filters--only that "help" doesn't cover my
situation. I should be able to filter either in the query, in another new
query, in a form (add to the loop), or in the report. But how?
I think I'm using Access 2003, but my database was created in Access 2000.
I'm also learning Access via OJT, so I may ask stupid or obscure questions.
Please be kind to a novice.
books--title, author, etc.--and a table of keywords connected by the common
key "Book ID". These come together in a parameter query in which the
parameter value is "keyword". The "keywords" field usually includes several
keywords, separated by commas. If I just run the query as is, I get a
report, but the records include only those books with keyword fields
containing that one keyword and no others; I don't get the other books where
that keyword is one of several. For example, if I answer the parameter query
with the word "pavement", my report shows four books; there are fifteen books
that contain the word pavement in the keyword field.
I think I need a filter that will select those records that contain the
keyword. I know nothing about filters--only that "help" doesn't cover my
situation. I should be able to filter either in the query, in another new
query, in a form (add to the loop), or in the report. But how?
I think I'm using Access 2003, but my database was created in Access 2000.
I'm also learning Access via OJT, so I may ask stupid or obscure questions.
Please be kind to a novice.