Multiple SQL Statements ...

[stmartin]

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!

[bashfirst]

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

Bash