title: Fnd 2nd occourance of a string in a Memo Field
body: <p>I have a memo field called "Worklog". 
  My table name is: MissingT. 
  I would like to run a query which can find a specific string and get the next 6 digits following that specific string. </p>
  
  <p>The string would look like below:</p>
  
  <pre><code>Status: Work in Progress
   Submitted: December 5, 2014 - 8:44:53 AM EST
   Approval Status: Approved
   Date Approved: December 5, 2014 - 8:44:53 AM EST
    
   SECTION 1 - REQUESTER PROFILE
   User ID: xxx111
   Name: Some, Name
   Phone #: 999-999-999
   Region: Canada
    
   SECTION 2 - AUTHORIZED INDIVIDUAL PROFILE
   User ID: xxx222
   Name: Some, name2
   Phone #:999-999-9999
   Title: Manager
  </code></pre>
  
  <p>I want the query to get the user id under section 2. My current query finds the User ID under section 1 and gets the 6 strings following it (xxx111). How can I move the query to get the 2nd occurrence of string "User ID" and the 6 strings following it. </p>
  
  <pre><code>UPDATE MissingT SET MissingT.AuthManager = mid([Worklog],(InStr([Worklog],'User ID: ')+8),7)
  WHERE (((MissingT.[worklog]) Like  "*" &amp; 'User ID:' &amp; "*"  ));
  </code></pre>