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.

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.

thank you