Change right to mid That is what I did and the whole thing worked Mid([Table1].[Test],InStr([Table1].[Test]," ")) AS Last
Separate names with a comma.