If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
splitting field into 2
I am working with Access tables given to me by a client and incorporating
their data into a larger database. The old tables have the first name and last name in one field, which most of us know it's a no-no in database world. The last name is first, followed by a comma (no space), then the first name. Here's an example, "Smith,John". How can I separate the last name into its own field and likewise for the first name? The lengths of the names vary, so it's not possible to specify the number of characters in using Left, Mid, or Right coding. Is there a way to use the comma as a separator? Thank you! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form, Subform, Tab key | 2nd_Stage_User | Using Forms | 17 | August 25th, 2006 12:30 AM |
Enter text in a field and have it appear as entered elsewhere | Gregory Winters | General Discussion | 6 | November 1st, 2005 02:09 AM |
Splitting Text Field | sfcwarren | Running & Setting Up Queries | 1 | March 7th, 2005 06:22 PM |
Splitting a field | David# | Running & Setting Up Queries | 2 | February 28th, 2005 03:19 PM |
field manipulation | Steve | Running & Setting Up Queries | 2 | May 28th, 2004 03:12 PM |