Hi all,
I wonder if someone can help me with what should be a simple task.
I have a table of user details that has been imported from an Oracle database.
Within this table are two fields Personnel Number and ID.
I would like each field to reflect the correct value for this field and if required split the personnel field across personnel and ID.
For example.
In the personnel field might currently be AB1234, this would be correct, however it may read AB1234 - 1234567, in this particular instance personnel should read AB1234 and ID should read 1234567, thus stripping out the - and writing the value to ID.
If the personnel field was to read just 1234567 I would want this to be blanked out and the value of 1234567 written to the ID field.
Can anyone offer any suggestions with this? I am aware that Excel has a Text To Columns facility that, does to some degree what I am trying to achieve, but surely there is an easier way of achieving this in Access? The table I am manipulation has in excess of 7.5k records.
Any help that anyone can offer is greatly appreciated.
Kindest regards,
Kev
I wonder if someone can help me with what should be a simple task.
I have a table of user details that has been imported from an Oracle database.
Within this table are two fields Personnel Number and ID.
I would like each field to reflect the correct value for this field and if required split the personnel field across personnel and ID.
For example.
In the personnel field might currently be AB1234, this would be correct, however it may read AB1234 - 1234567, in this particular instance personnel should read AB1234 and ID should read 1234567, thus stripping out the - and writing the value to ID.
If the personnel field was to read just 1234567 I would want this to be blanked out and the value of 1234567 written to the ID field.
Can anyone offer any suggestions with this? I am aware that Excel has a Text To Columns facility that, does to some degree what I am trying to achieve, but surely there is an easier way of achieving this in Access? The table I am manipulation has in excess of 7.5k records.
Any help that anyone can offer is greatly appreciated.
Kindest regards,
Kev