Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m Confident and thankful

Search Criteria

I'm using Access Mobile with a 97 mdb database.
It works perfectly and it is a great help for my daily work.
The only question I have with this app is because I'm not finding "Contains" as a search criteria.
I only find "is", "is not", "begin with" and "end with".
It would be very important and I would appreciate it if it were possible to introduce "Contains" as a search criteria.
1 person likes
this idea
+1
Reply
  • Nuno - In case you haven't found a solution yet, you can do contains using a SQL query that does a "LIKE" query condition.

    For example, I have a database of books and I use the following query to search it:

    SELECT books.*
    FROM books
    WHERE UCase(books.Title + books.Author + books.ISBN + books.Notes) LIKE UCase('%xxxxx%')
    ORDER BY books.Title;

    What this does is search over 4 columns that I concatenate together for that purpose. I normalize everything by making the data all uppercase, as I do my search criteria. I user LIKE '%xxxxx%' as my search criteria, where I can simply select and change xxxxx to whatever I want. The % signs act as leading and trailing wildcards, which is how one can do a contains.

    This is one example.

    Note: I actually have this query saved in a table I call "Saved Queries", with a column called QueryName and a column called QueryString, the latter is the actual SQL above. So what that allows me to do is to copy the SQL in the App and paste it for my search criteria in the App. I need only change the xxxxx and I'm good to go.

    HTH,

    Dan
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited