1 field into 2 fields

[dorodon]

I have a table with a field for the complete name of a person (for instance "John Walker") and I want to make a query to divide that field into 2 new fields: "Name" and "Surname", that is, "John" and "Walker".

How to do it?

Thanks in advance

 

[NoMAd]

i dont quite understand..
why dont you just edit your table.. and do an insert if thats what you need to do.. you cant "split" fields through a query.. umm yeah.. i dont really understand though..

explain more..

 

[Mile-O]

Add two new fields to your table: Forename and Surname.

Open a query, switch to SQL View and copy and past this SQL in.

UPDATE MyTable SET Forename = Left([NameField], InStr(1, [NameField], " ")-1), Surname = Mid([NameField], InStr(1, [NameField], " "(+1);

Change MyTable to the name of your table.
Change NameField to the name of your current field.
I've named the field Forename and not Name as Name is a reserved word in Access.