Break apart a Whole Name

[Guest]

I use A2003
===

I have a column or field named WholeName, e.g., Doe, John

How do I write an expression to break the WholeNames down into 2 columns:
LastName and FirstName, e.g., Doe and then John

Thank you

 

[Douglas J. Steele]

If you've always got the comma like that, then you can use the InStr, Left
and Mid functions:

FirstName: Mid([WholeName], InStr([WholeName], ",") + 1)
LastName: Left([WholeName], InStr([WholeName], ",") - 1)

You'd use the above as computed fields in a query: you shouldn't be storing
the information redundantly.

 

[Guest]

Thank you

Works beautifully

Will take heed of your admonition

Peace

If you've always got the comma like that, then you can use the InStr, Left
and Mid functions:

FirstName: Mid([WholeName], InStr([WholeName], ",") + 1)
LastName: Left([WholeName], InStr([WholeName], ",") - 1)

You'd use the above as computed fields in a query: you shouldn't be storing
the information redundantly.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I use A2003
===

I have a column or field named WholeName, e.g., Doe, John

How do I write an expression to break the WholeNames down into 2 columns:
LastName and FirstName, e.g., Doe and then John

Thank you