Results 1 to 3 of 3

Thread: LastRecord

  1. #1
    Tam Nguyen Guest

    Default LastRecord

    Hello,<BR><BR>Can someone show me how to display the last record on the Access database online using ASP and ADO? I only want to display the most recent record online. Thank you.

  2. #2
    Jason Miller Guest

    Default RE: LastRecord

    select top 1 &#060;columns or *&#062; from [tableName] &#060;where clause&#062; order by &#060;timeStamp or something&#062; desc

  3. #3
    Tam Nguyen Guest

    Default RE: LastRecord

    Thanks for replying. I did try to use the SQL you told me but it displays the whole records in the database with descending order. However, I only want to display the most recent record. In other words, I want to display one last record (recent update) only. Please help. I know I can do it in Access using Max to pick up the most recent record or Min for the the first record(oldest record). Thanks alot.

Posting Permissions

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