Just another quick (I hope) question...
I'm importing some information into a contact list from an old table, and I just realized that the names in the old table are stored as one string, while in the new one I need them in two seperate strings. I'm using an append query to bring over some other information, and I was wondering if there's some way to split the names at a ' ' (space) character and then place the two pieces (first and last name hopefully), into two seperate fields..... I think this is possible, I just dont know the functions to use...
thanks again
-Cavern
I'm importing some information into a contact list from an old table, and I just realized that the names in the old table are stored as one string, while in the new one I need them in two seperate strings. I'm using an append query to bring over some other information, and I was wondering if there's some way to split the names at a ' ' (space) character and then place the two pieces (first and last name hopefully), into two seperate fields..... I think this is possible, I just dont know the functions to use...
thanks again
-Cavern