How do put first and last name in separate fields.

[rudenberg2013]

Hi, my name's Bernardo.I'm from Brazil, I don't speak english , I'm using the translate at Google. I have many names in Access and have to put the first name in a field and the second name (surname) in another field (table). How phaco this?

[AlexHedley]

http://www.599cd.com/tips/access/131...?key=AlexForum

Mod edit: delete duplicate thread originally referenced and replaced link with link from duplicate thread

[June7]

Try

SELECT Left([Names of employees], InStr([Names of employees]," ")) As FirstName, Mid([Names of employees], InStr([Names of employees]," ")+1) As LastName FROM Names;

[rudenberg2013]

sorry but I did not understand. Where do I put this code ?

[AlexHedley]

@June7 has given you a SQL Statement.
Choose "Create Query" on the Ribbon.
There will be an icon you can dropdown on the top left, choose SQL then past this code in and press Run.

[rudenberg2013]

thank you so much. I'll follow instructions.

[rudenberg2013]

you can post the database with code to download and I understand. Thank you.

[AlexHedley]

Which part(s) were you struggling with?

These screens are old but this article will be of use:
http://office.microsoft.com/en-gb/ac...010247313.aspx

[rudenberg2013]

The code it is ok, thanks to all.

[rudenberg2013]

thank you so much, thank you so much