Phil,
What you need is an update query on your table.
Start by making a back-up copy of your table, just in case...
Make a new query in design view, and add the table. Then take field1 and
field2 down to the design grid.
Go to menu item Query > Update to make it an update query.
Notice a new line labelled Update to appearing in the grid. Go to this line
and type in the following expressions below field1 and field2 respectively
(I'll assume the name of field1 is "Field1", change to the actual field
name):
Left([Field1],3)
Right([Field1],5)
Now press the Run button (the one with the red exclamation mark) in the
toolbar, or got to menu item Query > Run, to run the query, and you're
done!
HTH,
Nikos
Phil Jones said:
I have a number of feilds in a table that I need to split the data between.
In feild1 the first 3 charaters are to stay in the feild and the last 5 need
to be moved to feild2 can anyone advise how I can do this?
Thanks
Phil
