extracting data from a field in a table.

[darksniper]

when I have created my table I have created a field called name that stored both last and first name. Right now I need to extract the the last name from the the field name and store it in another field "lastName". Any ways to do that?

 

[FoFa]

Yes, depending on the format in the "name" field will be how hard or easy it is.

 

[darksniper]

it is a text field. and the data in that field would be something like this: "John Wood" or "Arnold Terminator" as an example.

 

[Moniker]

If the separator between first and last name is always a space and you have no middle names, this will work:

LastName = Right([Name],Len([Name])-InstrRev([Name]," "))
FirstName = Trim(Left([Name],InStr(1,[Name]," ")))

 

[darksniper]

thx, I'll try it out right away!

 

[darksniper]

allthough the only thing I forgot to ask, where do I put the code?

 

[neileg]

As a calculated field in a query.

 

[darksniper]

works great, thx...