I'm not sure of the results but try this:

SELECT DISTINCT tblStudents.LName & " " & tblStudents.FName as Name

Just replace the first part of the select statement where you are referring to the first and the last name. You might also have to change the ORDER BY to Name.

Chris