splitting column text

S

Sarah

i feel a little dumb, but i just can't remember how to do
this:

i have a column that holds the first and last names of
clients, but i want to split the column into two so that
i have one column of first names and one column of last
names.

how do i do this?
 
W

Wayne Morgan

Create an update query to update the two fields after you create them in the
table. Update them to

FirstName:Trim(Left([NameField], InStr([NameField], ",")-1))
LastName:Trim(Mid([NameField], InStr([NameField], ",") +1))
 
S

singinghope

I tried this and get an error message that says "invalid
procedure call" when i try to run the query
-----Original Message-----
Create an update query to update the two fields after you create them in the
table. Update them to

FirstName:Trim(Left([NameField], InStr([NameField], ",")- 1))
LastName:Trim(Mid([NameField], InStr([NameField], ",") +1))

--
Wayne Morgan
Microsoft Access MVP


Sarah said:
i feel a little dumb, but i just can't remember how to do
this:

i have a column that holds the first and last names of
clients, but i want to split the column into two so that
i have one column of first names and one column of last
names.

how do i do this?
Click to expand...


.
Click to expand...
 
Top