table display of sql qry

[Psyrus]

I still think the GROUP BY should work. Something like this:

SELECT
tblStudents.LName & " " & tblStudents.FName as Name, tblStudents.SSN, tblStudents.Rate, tblStudents.Rank, tblStudents.OnBdDate, tblStudents.Dept, tblStudents.School, tblStudents.Clerk, tblEvents.EventNum, tblEvents.EventDate, tblEvents.EventCode, tblEventCode.ABBRNM, tblEventCode.NM, tblEvents.Notes, tblEventCode.holdType
FROM
tblEventCode, tblStudents, tblEvents
GROUP BY
Name
HAVING
tblStudents.PKN = tblEvents.PKN
AND
tblEventCode.EventCode = tblEvents.EventCode
ORDER BY
Name ASC

Let me know if this works.


Chris