Rotating text

  • Thread starter Thread starter Bill Smith
  • Start date Start date
B

Bill Smith

In my tables, names are held as surname followed by a
colon followed by first names. So William George Smith is
stored as Smith:William George.

When the names appear in reports, I need to 'rotate
around the colon' to print William George Smith.

My understanding is that there is a function which will
return a string character by character until a specified
character is encountered. This sounds promising - or
perhaps there's a better way.

Thanks for any help.

Bill Smith
 
Try:
Split([YourNameField], ":")(1) & " " & Split([YourNameField], ":")(0)

In older versions, you would need to use a InStr() to locate the colon, with
Left(), Mid(), Len(), and IIf().

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.


news:[email protected]...
 
Back
Top