possible to seperate entries in a field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm a relatively new user, and I'm not sure how to do what I need to do, and am running out of time. I'm working on a video library and I have a text field for keywords where the user entering in a new piece of footage would put keywords for stuff that is in the footage. For example, say the footage is of a day at the park, the user might enter something like "trees, people, playground, benches" in the keywords field. What we want to be able to do is submit a query or search for a keyword and get a list of all the tapes that contain footage matching the keyword. Is this possible? If so, how do I do it, or where exaclty in the help file would I need to look for information on how to do it? I'm hoping it's something as simple as just separating the keywords with semicolons instead of commas or something like that
Any help or info would be greatly appreciated!
 
Have a look in the help for the a "Like" clause in SQL.
For example if a field contained the three rows of data
Row 1 "Yorkshire" Row 2 "York Stone" Row 3 "Duke of York"
searching for - LIKE "York" would return all three
records. You do not have to write the SQL by hand - you
can right click on the "Criteria" row in the query
builder and select the "Build" option and use this to
generate the SQL which can then be viewed and modified in
SQL view.

You might also reconsider the design of your database to
give more control over the keywords. As a simple example
if the database were to have three text fields for
keyword entry some, or all, of which were limited to
known keywords (categories) by means of a predefined
value list (using a list box or combo box) then searching
would be easier:

Field 1 General Categories:
"Science", "Nature", "Computing" etc.

Field 2 Sub categories (dependant on the value of Field 1)
"Physics", "Chemistry", Medicine"

Field 3 Further sub categories or possibly free form text.

and so on...

Hope this helps!
-----Original Message-----
I'm a relatively new user, and I'm not sure how to do
Click to expand...
what I need to do, and am running out of time. I'm
working on a video library and I have a text field for
keywords where the user entering in a new piece of
footage would put keywords for stuff that is in the
footage. For example, say the footage is of a day at the
park, the user might enter something like "trees, people,
playground, benches" in the keywords field. What we want
to be able to do is submit a query or search for a
keyword and get a list of all the tapes that contain
footage matching the keyword. Is this possible? If so,
how do I do it, or where exaclty in the help file would I
need to look for information on how to do it? I'm hoping
it's something as simple as just separating the keywords
with semicolons instead of commas or something like that.
 
Back
Top