G Guest Nov 18, 2006 #1 I have a field that contains a last name, first name, id#. How can I pull the name and number separately?
I have a field that contains a last name, first name, id#. How can I pull the name and number separately?
R ruralguy via AccessMonster.com Nov 18, 2006 #2 You might look at the Split() function using a comma as the separator.
A Allen Browne Nov 18, 2006 #3 If there are exactly 3 parts, always separated by a single space, you can use Instr() to locate the space, and Left(), and Mid() to parse the words. Alternatively, this might help: ParseWord(): Parses the first, last, or n-th word/item from a field/list at: http://allenbrowne.com/func-10.html
If there are exactly 3 parts, always separated by a single space, you can use Instr() to locate the space, and Left(), and Mid() to parse the words. Alternatively, this might help: ParseWord(): Parses the first, last, or n-th word/item from a field/list at: http://allenbrowne.com/func-10.html
J Joseph Meehan Nov 18, 2006 #4 kltino said: I have a field that contains a last name, first name, id#. How can I pull the name and number separately? Click to expand... You might want to give some details about exactly how the data is recorded (spaces commas etc.) and how consistent the data is, Joseph E. Meehan Joseph E Meehan Joseph Edward Meehan Joseph Meehan Joseph, Meehan Joseph,Meehan etc. I hope you asked this question because you want to separate the data into logical fields like Fname, Mname, Lname.
kltino said: I have a field that contains a last name, first name, id#. How can I pull the name and number separately? Click to expand... You might want to give some details about exactly how the data is recorded (spaces commas etc.) and how consistent the data is, Joseph E. Meehan Joseph E Meehan Joseph Edward Meehan Joseph Meehan Joseph, Meehan Joseph,Meehan etc. I hope you asked this question because you want to separate the data into logical fields like Fname, Mname, Lname.
