Results 1 to 3 of 3
  1. #1
    wbaroudi is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2019
    Posts
    10

    Post Query advice

    Hi guys,

    I am asking for advice rather complicate things for myself.


    I have a column that has a mobile number but sometimes the call agent would put wrong information such as :07999412113, 07999 412113 or mobile07999412113 and when it comes to automating sending SMSs this would fail. I have got rid of the space
    using Mobile: Replace([2_Join_Surgery_With_Address]![LCD - Mobile No]," ","") and works fine.

    Now I need to check if the mobile number does not begin with 07 and remove everything up to that point and I can get my head around it.

    I wonder if someone can help please.

    thank you for looking.

    Regards


    Wessam

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    what about users putting +34 7999 412113 rather than 07999 412113?

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

Similar Threads

  1. Just looking for some Advice please
    By Crystan in forum SharePoint
    Replies: 1
    Last Post: 06-12-2019, 06:35 AM
  2. Newbie - Query Advice Please
    By DNDPMick in forum Queries
    Replies: 3
    Last Post: 01-22-2016, 01:05 PM
  3. Need basic advice on using Count in a query
    By Sam_NY in forum Queries
    Replies: 6
    Last Post: 06-05-2015, 09:48 AM
  4. Query for Reconciliation - Help/advice needed
    By Chatholo in forum Queries
    Replies: 4
    Last Post: 02-02-2015, 03:03 PM
  5. Replies: 7
    Last Post: 03-17-2013, 07:12 AM

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