Results 1 to 4 of 4
  1. 08-19-2014, 08:16 AM #1
    Amthyst826
    Amthyst826 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2013
    Location
    Fullerton, Ca
    Posts
    11

    Smile Use mid to pull numbers out of another field

    My six column table has a column titled Charm 08114_IAN/ABC which has a 13 digit numeric value
    I want to create a seventh new column, which contains digits 2 through 6

    I thought it would be something like this
    ABCID: Mid([CHARM 081114_IAN/ABC]),2,5)

    I am getting an invalid syntax error

    Help please
    Reply With Quote Reply With Quote
  2. 08-19-2014, 08:30 AM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    You have an extra parentheses:

    ABCID: Mid([CHARM 081114_IAN/ABC]),2,5)
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  3. 08-19-2014, 08:42 AM #3
    Amthyst826
    Amthyst826 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2013
    Location
    Fullerton, Ca
    Posts
    11
    doh!
    Thanks!!
    Reply With Quote Reply With Quote
  4. 08-19-2014, 09:01 AM #4
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Report field: Pull data from different table based on value in different field
    By fsask2013 in forum Reports
    Replies: 2
    Last Post: 03-07-2013, 04:50 PM
  2. Pull value from one field to a specific record
    By Newbie2 in forum Forms
    Replies: 1
    Last Post: 08-01-2012, 12:50 AM
  3. Pull records only when a specific field are blank
    By jalb in forum Reports
    Replies: 2
    Last Post: 02-22-2012, 02:36 AM
  4. Pull data from a field in a parent record with VBA
    By tylerg11 in forum Forms
    Replies: 5
    Last Post: 12-22-2011, 11:01 AM
  5. using a combo to pull up multiple values in the same field
    By ronandamanda114 in forum Forms
    Replies: 0
    Last Post: 12-19-2006, 09:44 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums