Results 1 to 7 of 7

Thread: How to get exactly row 6 from a SELECT result in Access 2000 SQL?

Threaded View

  1. Jul 3rd, 2018, 08:10 AM #2
    Zvoni
    Zvoni is offline
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    5,277

    Re: How to get exactly row 6 from a SELECT result in Access 2000 SQL?

    You don't, since access doesn't have a ROW_NUMBER-Function.
    See your other thread.
    I've told you there is a workaround using DCOUNT

    EDIT: There is a second workaround i just thought of:
    You could use the TOP n -function, and then retrieve the last recordset, but obviously, this would only work on sorted queries (ORDER BY-clause)

    rs.open "SELECT TOP 6 ID, clientname FROM myclient ORDER BY Turnover",blahblah
    rs.movelast
    Last edited by Zvoni; Jul 3rd, 2018 at 08:24 AM.
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    ----------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this 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