VB name reverse.

[Hendy]

I have a table of Authors List First Name Surname, I want to use VB to change the authors to surname, first name. I know there will be some exception and will have to change and check the data but can anyone help me to sort out the majority.

Thanks
Mark [sig][/sig]

 

[NickThompson]

Mark

If you send your email address to nickt@europe.com I'll send you a module I wrote to do exactly this. It takes account of more complex names like 'van de Tramp' etc.

Nick [sig][/sig]