Separate Name fields to initials

[hardrock]

Hi all, I'm trying to splitt the name of the clients in my query into a column called Initials:

Their 'Names' are in this format

SMITH,JOHN
JONES,PETER

Therefore in Initials, i want to see in column Initials

JS
PJ

How do i do this please? Many thanks

 

[Dennisk]

use the INSTR() function to determine where the comma is then use the MID$() function to Extract the first letter after to comma.

 

[hardrock]

re:

Thanks! i sorted it