Split from a thread in Visual Basic forumI have a similar problem. can you guys help?
Moderator
I am trying to find multiple entries that meet my criteria.
this works great for the first one. There could be any number of 9 digit Work Order numbers that I need to extract.
Work_Order: IIf(IIf(InStr(1,[ML]![Description],"200")>0,Val(Mid([ML]![Description],InStr(1,[ML]![Description],"200"),9)))>200000000,Mid([ML]![Description],InStr(1,[ML]![Description],"200"),9))
Example result = 200158687. My problem is this field has more than 1 number that I need to extract. My result table has 2 columns: named
CRnum and Description. I need a record for each Work_Order
1 CRnum has many Work Orders.
ie:
Column1 Column2
CRnum Work_Order.