Extract initial character from field in MS Access
I have a table with this record
Title Name
Rumah Sakit Puri Medika
I want to extract initial character from each field so it will dis开发者_JS百科play "RSPM"
Thanks
SELECT Left([Title], 1) &
Mid([Title], InStr([Title]," ") + 1, 1) &
Left([Name], 1) &
Mid([Name], InStr([Name]," ") +1, 1)
精彩评论