Space: InStr(1,[Members]![Name]," ") First: Left([Members]![Name],[Space]) Last: Mid([Members]![Name],[Space]+1,20)