Quote:
Originally Posted by 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.
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.
