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
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Splitting Forename & Surname in one cell | Richard | Worksheet Functions | 2 | February 25th, 2004 11:55 AM |