By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,666 Members | 1,603 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,666 IT Pros & Developers. It's quick & easy.

How to extract multiple entries

P: 20
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.
Apr 28 '07 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,530
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
Expand|Select|Wrap|Line Numbers
  1. Field; Type; IndexInfo
  2. StudentID; Autonumber; PK
  3. Family; String; FK
  4. Name; String
  5. University; String; FK
  6. Mark; Numeric
  7. LastAttendance; Date/Time
MODERATOR.
Apr 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.