Results 1 to 2 of 2
  1. #1
    Chase is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Sep 2012
    Posts
    2

    edit contain query to exclude certain results

    I've created a query where I am searching a database of job titles for contacts that are considered senior management.

    One criteria I've entered into a query is as follows:


    Like "*Vice*"
    which is meant to identify anyone with "Vice" in the title. The problem is I have noticed this also returns records with "service".
    So can I edit this query to specify that the "V" must be capitalized? I think this would serve.
    Other suggestions welcome.

    Thanks in advance!

  2. #2
    Chase is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Sep 2012
    Posts
    2
    Actually i think i figured it out I used
    Like "Vice*"
    and
    Like " Vice*"
    which together will not pick up "service" or accidentally exclude records that contain "Vice" but don't begin with it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Query to exclude non matching records
    By L1882 in forum Queries
    Replies: 1
    Last Post: 04-03-2012, 08:44 AM
  2. Edit Results
    By ShadeRF in forum Reports
    Replies: 1
    Last Post: 11-18-2011, 02:03 PM
  3. exclude field in query
    By chrisy in forum Queries
    Replies: 2
    Last Post: 10-28-2011, 09:53 AM
  4. Replies: 4
    Last Post: 10-25-2011, 10:07 PM
  5. Replies: 2
    Last Post: 10-08-2011, 06:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums