Results 1 to 2 of 2

Thread: Multiple SQL Statements ...

  1. Jun 29th, 1999, 10:13 PM #1
    stmartin
    stmartin is offline

    Thread Starter
    New Member
    Join Date
    Jun 1999
    Location
    Decatur, AL US
    Posts
    14

    Post

    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!
    Reply With Quote Reply With Quote
  2. Jun 29th, 1999, 10:47 PM #2
    bashfirst
    bashfirst is offline
    Lively Member
    Join Date
    Jun 1999
    Location
    Raleigh, NC
    Posts
    70

    Post

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

    Bash
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width