I have a table in MS Access shown below. I am able to display the score for quiz_id=1. However, it will not display scores when I attempt to write sql statements (shown below) for 2, 3, and 4. Please advise..

MS ACCESS TABLE:
StudentTable

StudentID quiz_id Score
123456789 1 100
123456789 2 75
123456789 3 45
123456789 4 75

<%
sqltext1 = "SELECT * FROM StudentTable WHERE StudentID='" & Session("username") & "'"
oRS.Open sqltext1, oConn

IF oRS("quiz_id") = "1" Then
Response.Write "" & oRS("Score") & "%" & ""
Else

Response.Write "0"

End If
oRs.Close
%>


</td>
<td width="125" align="center">

<%
sqltext2 = "SELECT * FROM StudentTable WHERE StudentID='" & Session("username") & "'"
oRS.Open sqltext1, oConn

IF oRS("quiz_id") = "2" Then
Response.Write "" & oRS("Score") & "%" & ""
Else

Response.Write "0"

End If
oRs.Close
%>

Repeat for 3 and 4.
The only score that displaysis when quiz_id = 1

It looks like you don't quite understand how recordsets work, so let's go through your code and explain what's happening.

After this first bit of code is run:
you have a recordset (oRS) which contains all 4 records, and its automatically positioned at the first record, so when you do the test:
the result is TRUE and so the score is written to the browser by your next line of code.

So, when you repeat the code:
you again get a recordset containing all 4 records which is positioned at the first record, so this time your test:
fails.

So, can you see that instead of repeating the SQL, all you need to do is oRS.MoveNext? That will position the recordset to the second record (the one with quizid=2). Personally I would add an ORDER BY clause to the SQL to ensure you always get the records back in the sequence you expect:
SELECT * FROM StudentTable WHERE StudentID='" & Session("username") & "' ORDER BY StudentID, quiz_id"

hth
Phil

Thanks Phil! Yes, I am new to asp. I will try your suggestion!

Better late than never eh?

set oRS = server.createobject("adodb.recordset")
sqltext1 = "SELECT * FROM StudentTable WHERE StudentID='" & Session("username") & "'"
oRS.Open sqltext1, oConn
if not oRS.eof then
    do while not oRS.eof
    response.write "<tr><td>" & oRS("Score") & "%</td></tr>"
    oRS.movenext
    loop
end if
oRS.close
set oRS = nothing