first name surname swop

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

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


"blackcat" wrote in message
...
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

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.

--

Ken Snell
MS ACCESS MVP

"blackcat" wrote in message
...
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