first name surname swop

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

blackcat - 17 Dec 2004 14:05 GMT

anyone know how to have one field for say author and then swop the text round
as in enter john smith and save and display as smith, john

Reply to this Message

Rick B - 17 Dec 2004 14:30 GMT

You would save the first and last name in two separate fields if you need to
be able to do this easily.

> anyone know how to have one field for say author and then swop the text round
> as in enter john smith and save and display as smith, john

Reply to this Message

Ken Snell [MVP] - 17 Dec 2004 14:30 GMT

Yes, if you can always use a space to delineate between the first and last
names... which doesn't work for authors with three or four names.

You'll be better to have separate fields for the first, middle, and last
name, and then it'll be easy for you to concatenate the values in any way
you wish.

Signature

Ken Snell
<MS ACCESS MVP>

> anyone know how to have one field for say author and then swop the text
> round
> as in enter john smith and save and display as smith, john

Reply to this Message