Re: Rotating text
From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 02/22/04
- Next message: colmobrien: "help with report from query which has a custom dialog (newbie)"
- Previous message: Bill Smith: "Rotating text"
- In reply to: Bill Smith: "Rotating text"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 22 Feb 2004 16:59:15 +0800
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. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Bill Smith" <anonymous@discussions.microsoft.com> wrote in message news:1459d01c3f920$87a086e0$a001280a@phx.gbl... > 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
- Next message: colmobrien: "help with report from query which has a custom dialog (newbie)"
- Previous message: Bill Smith: "Rotating text"
- In reply to: Bill Smith: "Rotating text"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
