How query using keywork criteria

Posted on 2014-08-15
Last Modified: 2014-08-15
I have a table that has a field named "Keywords".  In the table are two records so far.  In the keyword field one record has "Baseball".  The other record has "Football Baseball".  Then I am designing a query and the criteria is:

Like "*" & [Forms]![frmSearchByKeyword]![txtKeyword] & "*"

And I have a "Search" form with a field named txtKeyword.

But for some reason when I enter "Baseball" in the text field and run the query I get only the record that has "Football Baseball".   The query does not return the record ALSO that has "Baseball".

What is wrong with this?
Question by:SteveL13
    LVL 119

    Accepted Solution

    check carefully the entries in your table. (space,spelling etc...)

    your query should return both records
    LVL 39

    Expert Comment

    Look at sample. Criteria like yours

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now