split field into two fields

[fletch]

Hi,

I have a table that has a lastname field in it that contains firstname space and lastname.

I also have a firstname field.

I need to split that lastname field into the firstname and lastname fields.

I have no idea how to do this.

I can create basic queries, I've done update ones, and a few others so I'm not a total beginner. Just don't know how to do this.

 

[Rich_Lovina]

Your easiest way is to use the Search Engine in this Forum and type "Split Fields", and you'll get 61 postings that discuss the many ways to handle this.

 

[fletch]

thank you