possible to seperate entries in a field?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Itareus (anonymous_at_discussions.microsoft.com)
Date: 02/06/04 

Date: Fri, 6 Feb 2004 14:29:32 -0800

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
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!
>.
>

Relevant Pages

  • Re: VSS with SQL server
    ... Just curious what SQL syntax file you're using ... The keyword list (Keywords 1) is SQL Server Reserved Keyword list. ...
    (microsoft.public.sqlserver.server)
  • Re: Searching for misspelled keywords?
    ... AKG wrote: ... > VARCHAR field of a table. ... > I know there is Full-Text Catalog in SQL Server but it doesn't suggest ... > Please note that I need to search for one or more keywords in VARCHAR ...
    (microsoft.public.sqlserver.programming)
  • RE: VBA variable to population Table Question
    ... Stuart posted the revised code. ... Dim SQL As String ... The single quotes delimit the text string. ... DoCmd.RunSQL ("INSERT INTO Keywords (ReferenceID, ...
    (microsoft.public.access.formscoding)
  • Re: Multiple action queries
    ... you should assume everyone here has very limited experience. ... SQL has a PROCEDURE keyword and the regulars round here ... The ghettoised 'parameter query' doesn't translate well when the ... BTW I tend to quote SQL keywords in uppercase, ...
    (microsoft.public.access.gettingstarted)
  • Re: searching on more than one field in VB
    ... information (keywords) into more than one of the seven textboxes and have any ... Much like SQL SELECT with multiple fields ANDed together. ... "Tom Ogilvy" wrote: ...
    (microsoft.public.excel.programming)