let me try to be more specific:

table name - heldapps

column names:

studentnumber, applicationid, lastname, firstname

several studentid's can belong to one applicationID. I need the qry to only pull 1 name...