criteria

[Chi]

Hi,

The INFORMATION field stored any things: number, text and Date.

EX: 12/01/07 :Namenda 10 mg.
9/8/ 06 :Namenda 5 mg.
Aricept 10 mg.
Failure to Aricept
Not on anything
Ok
See Smith-Sue



The data in the Information field will change each time I import the Excel
file to Access table.

I think that it is impossible to have criteria for this case, but I am trying.


Is there a "general criteria" that I can use to pull out some specific
records?

For this time, I would like to put out the records: ok and not on anything.

Thanks
Chi Huynh

 

[KARL DEWEY]

The INFORMATION field stored any things: number, text and Date.
Is your example showing 7 records?

You are going to need to convert the multiple records into a single record.
Are there any consistencies like does the first part always begin with a
date? Is there a blank between records?

 

[Chi]

Thanks for your response.
The INFORMATION field has about 200 records and most of them are not the
same text, dates or numbers.

Are there any consistencies like does the first part always begin with a
date? Is there a blank between records?

Some of them begin with dates, the others begin with numbers or text. And
there is no blank between records.

Thank you
Chi

 

[KARL DEWEY]

I guess you did not understand my question.

Does each record set contain 7 records?