Multiple SQL Statements ...

I have an SQL statement that sorts a record from MS Access ...

SELECT*FROM Transcripts WHERE studid = "423807372" order by date desc

I then need to read that sorted list and figure out what the most recent entries (X classes) and list those.

Basically I need to read the information that was sort by the previous SQL statement and operate on it.

Thanks in Advance!

Can't you specify the records you want all in one Sql statement? What determines the records you select from your initial recordset?

Bash