I have a project w/ a name field which contains first and last name. We have to divide this into 2 seperate fields, first name & last name. Any one know the code for how to do this? I am completely lost! Thanks for your help!
Posted: 6/27/2006 8:16:33 PM EDT
[#1]
Are you talking about trying to extract half of the data from one field and pasting it in a completely new field?
Posted: 6/27/2006 8:18:23 PM EDT
[#2]
Yes. The field has for example Smith, John. We have to take that and create a query that will seperate the Smith from the John. I have already created the last name & first name fields but I am stuck as to the coding part.
Posted: 6/27/2006 8:20:51 PM EDT
[#3]
I haven't dealt with Access in years. Try using the search within Access, seriously. I have solved several problems using that.
Sorry I couldn't be more helpful.
Brian
Posted: 6/27/2006 10:11:21 PM EDT
[#4]
If they all have commas separating the first & last, you could maybe save the original data as a CSV file, then import it.
I have a project w/ a name field which contains first and last name. We have to divide this into 2 seperate fields, first name & last name. Any one know the code for how to do this? I am completely lost! Thanks for your help! 