How to extract multiple entries

[RobertGabriel]

Split from a thread in Visual Basic forum
Moderator

I have a similar problem. can you guys help?
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.

[NeoPa]

It might be helpful if you explained the data structure.
It may be possible to reverse-engineer it from your code but I'm not sure that's going to get anyone to rush in with an answer.
Here is an example of how to post table MetaData :
Table Name=tblStudent

Field; Type; IndexInfo
StudentID; Autonumber; PK
Family; String; FK
Name; String
University; String; FK
Mark; Numeric
LastAttendance; Date/Time

MODERATOR.