Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006

    Query Out Specific Text

    I need to write a query that will eliminate text to the left of parenthesis and leave just what is in the parenthesis. For example:

    Original: ABC Company (Doe, Jane)

    Needs to be: (Doe, Jane)

    I have numerous companies and the only constant is the information is in parenthesis. I can easily remove this using a “find and replace” in the table but need to be able to do this using a query. I appreciate any assistance – thank-you!

  2. #2
    jobbie is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Apr 2014
    try this:

    Expr1: Mid([Field1],InStr([Field1],"("),InStrRev([Field1],")")-InStr([Field1],"(")+1)

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

Similar Threads

  1. Replies: 1
    Last Post: 10-09-2008, 04:48 AM
  2. making specific fields non-editable
    By narayanis in forum Forms
    Replies: 3
    Last Post: 08-06-2008, 12:22 PM
  3. Automatic Data Entry on a Specific Date
    By alanbrai in forum Programming
    Replies: 2
    Last Post: 11-14-2007, 05:15 PM
  4. Qry that asks for specific employee name
    By oxicottin in forum Queries
    Replies: 0
    Last Post: 02-05-2007, 08:50 PM
  5. Output Query to Text
    By denileigh in forum Queries
    Replies: 1
    Last Post: 05-27-2006, 12:34 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