Search results

Hi Ridders, your last query expression worked for 600 comments but when I tried the VBE code I received an error at line " strText = Mid(!Comments, InStr(!Comments, "-") - 3)" because I assume it is trying to grab a number between spaces, but one of our sales reps typed the number...

Hi again, So I figured out I could use this: txtPhone: Mid([comments],InStr([comments],"-")-3,12) However, some employees type their names as Doe-John, and it pulls that. So I need the query to grab a selection/str of text in the format of "***-***-****" Thank you

Hi ridders, The field name is “comments” and the data type is a memo. If I change the data type to text it cuts some of the text out. When I click design a query, what exactly should I type inside the field after I add the table: [comments]txtPhone=Mid(strText,InStr(strText,"-")-3,12)...

Hi All, I am trying to extra telephone numbers from several business reports. The narrative is usually type as follows: Example 1: 2016/12/31 20:10 Doe, John Desk105 front , 57yo male interested in purchasing cyber software for business 2016/12/31 20:11 Doe, John Desk105 front, call back...