Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    MTSPEER is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    283

    that worked for the records that have that criteria. But not all the records are messed up like that. some are normal with just the Email in the Email field and phone number in the Primary_Phone field.

  2. #17
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Yes, it is helpful to know all the different data situations you are dealing with.

    Let's just change the criteria to only run on records with the phrase "Primary Phone" in the Email field:
    Code:
    UPDATE Table1 
    SET Table1.Email = Left([Email],InStr([Email]," ")-1), 
    Table1.[Primary Phone] = Mid([Email],InStr([Email],"Primary Phone: ")+15,9)
    WHERE ((InStr([Email],"Primary Phone: ")>"0"));

  3. #18
    MTSPEER is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    283
    It worked! Thanks!

  4. #19
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You are welcome!

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 04-07-2016, 07:19 AM
  2. Left instr help
    By tmcrouse in forum Forms
    Replies: 2
    Last Post: 05-12-2015, 08:47 AM
  3. IIF with instr
    By yoili in forum Reports
    Replies: 2
    Last Post: 01-22-2013, 01:32 PM
  4. Using InStr() inside Mid()
    By urbi in forum Programming
    Replies: 12
    Last Post: 06-06-2012, 12:00 PM
  5. INSTR(), quick little syntax ?
    By markjkubicki in forum Forms
    Replies: 2
    Last Post: 11-15-2010, 02:46 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