|
Subject:
|
Separating a field into two fields
|
|
Posted By:
|
tp194
|
Post Date:
|
10/7/2004 11:00:34 PM
|
Hi
I have a name field in an access table that includes both first and last names.
I need to separate this out into a firstName field and a lastName field...
Sorry if this is a real newbie question, but and direction would be helpul.
Thanks
|
|
Reply By:
|
jemacc
|
Reply Date:
|
10/8/2004 10:02:14 AM
|
you can look information and len and substring
Jaime E. Maccou
Applications Analyst
|
