last five records entered

Results 1 to 2 of 2

Thread: last five records entered

  1. #1
    Join Date
    Dec 1969

    Default last five records entered

    how can i get result of the last five records entered, and the data about the record date n time, is in the table, every record time,,,

  2. #2
    Join Date
    Dec 1969

    Default SELECT TOP 5 ... ORDER BY ... DESC

    &nbsp;<BR>Do you mean that you want the 5 records with the latest date/time value? Or the 5 records with the highest autonumber ID value?<BR><BR>Not that it really matters:<BR><BR>SQL = "SELECT TOP 5 * FROM tablename ORDER BY fieldToOrderOn DESC"<BR><BR>That will get the records in reverse order (latest first).<BR><BR><BR>

Posting Permissions

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