Hi, I'm trying to display the following sql query on an html page:

strQuery = "SELECT tblStudents.LName, tblStudents.FName, 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 INNER JOIN (tblStudents INNER JOIN tblEvents ON tblStudents.PKN = tblEvents.PKN) ON tblEventCode.EventCode = tblEvents.EventCode"

(it is all in one line which is you don't see any ampersands, etc)

Here is my problem, The sql query works, in a table I can display everything I ask for. My problem is that I want to display just the name once, then each related event. Right now it prints the event with the name each time.

So basically I need it to look like this:

Name
event 1
event 2
event N
Name
event etc

Can anyone give me an idea or even a place to look?

Thanks