S
Steve
Hi,
For subject matter covered in my book collection, I have a field which in
table design view shows as type MEMO, into which in form view I copy/paste
keywords from a combo list of all the keywords I have in use, to ensure I
use the exact same spelling etc each time. I separate them in the large
window with commas.
There are hundreds of keywords to choose from so having a tick box type
field for each one would be impractical, also I am forever adding them.
I click in the box in form view and do a ctrl F and type the keyword, then
visually can see which books have that keyword.
If I want to create a report of these, I would need to run a query on that
field, then base the report on that query. However typing in the particular
keyword in Criteria sees speech marks surround it and running it sees nil
return. How can I call up records which have a certain keyword in that
field, and create a report of the book titles ?
Note the keyword can be a singular word, or made of two or three words with
spaces, I need to query both types.
Steve
For subject matter covered in my book collection, I have a field which in
table design view shows as type MEMO, into which in form view I copy/paste
keywords from a combo list of all the keywords I have in use, to ensure I
use the exact same spelling etc each time. I separate them in the large
window with commas.
There are hundreds of keywords to choose from so having a tick box type
field for each one would be impractical, also I am forever adding them.
I click in the box in form view and do a ctrl F and type the keyword, then
visually can see which books have that keyword.
If I want to create a report of these, I would need to run a query on that
field, then base the report on that query. However typing in the particular
keyword in Criteria sees speech marks surround it and running it sees nil
return. How can I call up records which have a certain keyword in that
field, and create a report of the book titles ?
Note the keyword can be a singular word, or made of two or three words with
spaces, I need to query both types.
Steve