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
|
|||
|
|||
Pulling specific data from table field
I am having a problem figuring the right way to pull specific data from
within the text of the table's field and separating it into a unique field alone. Anyway, my problem is that I need to copy a user's first name out of a field that contains system user information, and then pull the last name out separately as well, both uniquely. I don't mind having separate queries to do this (although one would be preferred of course). Table: tbl1 Field: userinfo Example of field data: ABD 000000 111, Doe John, R, W, T22222222, T333333 The ABC and 111 are constants within the field, and the 000000 is a serial number with a standard length of 6. I currently have a sql query that pulls the serial number: UPDATE tbl1 SET tbl1.[Serrial Number] = Right(Left([tbl1].[userinfo],10),6); Obviously this won't work with for a last name or first name because the number of letters within a name can change... so I'm stumped as how to correctly format a query to copy the last name and first name into a separate field. Any thoughts? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201006/1 |
Thread Tools | |
Display Modes | |
|
|