Extract Text

[gatarossi]

Dear all

I have this text in a field:

200701-I
200701-II
200701-III
200701-IV

and I need to separate only the data after the six first data:

-I
-II
-III
-IV

How can I do it?

Thanks a lot!!!

André.

 

[Jeff Boyce]

Take a look at Access HELP for the Mid() function. Open a query in design
view and add a new field something like:

NewField: Mid([YourField],7)

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Dear all

I have this text in a field:

200701-I
200701-II
200701-III
200701-IV

and I need to separate only the data after the six first data:

-I
-II
-III
-IV

How can I do it?

Thanks a lot!!!

André.