Change right to mid That is what I did and the whole thing worked

Mid([Table1].[Test],InStr([Table1].[Test]," ")) AS Last