extracting numeric values from text record set

[george13lucky]

Hi,

Please forgive my ignorance as i am a newbie on Access .

I have a field on in my table called Sch_Data with the following record .

3;875;646;697;1
3;875;712;770;1
3;53;880;893;1
4;4;697;712;1
4;6;780;825;0
4;5;900;915;1

this has been imported from another data source but i need to manipulate this value if i can in Access.

In the above record each line represents a different state for a given day and each semicolon separated value represents the following

(enum type,Stateid,Start_time,End_time,Paid or Unpaid)

and i need someway to recognise the integers in each line above because i will be trying to compare start times but also add durations for similar states.

I apologise if i am not expressing my problem accuartely as this is my first post.
Any help would be greatly appreciated.

[MMcCarthy]

Hi,

Please forgive my ignorance as i am a newbie on Access .

I have a field on in my table called Sch_Data with the following record .

3;875;646;697;1
3;875;712;770;1
3;53;880;893;1
4;4;697;712;1
4;6;780;825;0
4;5;900;915;1

this has been imported from another data source but i need to manipulate this value if i can in Access.

In the above record each line represents a different state for a given day and each semicolon separated value represents the following

(enum type,Stateid,Start_time,End_time,Paid or Unpaid)

and i need someway to recognise the integers in each line above because i will be trying to compare start times but also add durations for similar states.

I apologise if i am not expressing my problem accuartely as this is my first post.
Any help would be greatly appreciated.

You need to separate this data out into the individual fields.

The only ways to do this are when the data is first imported or using code.

[cyberdwarf]

Hint:-

Try the "Split" function...

Steve

[MMcCarthy]

Hint:-

Try the "Split" function...

Steve

I was originally going to suggest it but I don't think m$ are supporting it from 2007 onwards.

[cyberdwarf]

Aaww nuts!!! Thort I woz bein clever

[MMcCarthy]

Aaww nuts!!! Thort I woz bein clever

You were, you just didn't know that M$ were doing their usual "How can I mess up a load of applications when companies upgrade their Office version?"

[cyberdwarf]

You were, you just didn't know that M$ were doing their usual "How can I mess up a load of applications when companies upgrade their Office version?"

pas devant les enfants!