Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Top query

Discussion in 'Information Technology' started by Paradigm, Jul 28, 2006.

Tags:
  1. Paradigm

    Paradigm
    Expand Collapse
    Guest

    If I have a form that uses a query to show, say, the top 10 entries in a
    table, how would I have a command button to get it to display the next 20? I
    am using Aeccess 2K
    Alec
     
  2. Loading...

    Similar Threads Forum Date
    Opinion The Fallacy Of Top-Down Governance Sikh Sikhi Sikhism Dec 25, 2016
    Sikh American Attorney Harmeet Kaur Dhillon Elected To Top Position In Republican National Committee Sikh Personalities May 3, 2016
    day 2-the howling has stopped Blogs Oct 17, 2015
    Update Wikipedia enteries on Sikh Socio-Political Topics Breaking News Jul 19, 2015
    Duality-When Does The Screaming Stop? Sikh Sikhi Sikhism May 4, 2015

  3. Jamie Collins

    Jamie Collins
    Expand Collapse
    Guest

    Paradigm wrote:
    > If I have a form that uses a query to show, say, the top 10 entries in a
    > table, how would I have a command button to get it to display the next 20?


    TOP N constructs are proprietary Jet SQL syntax, so there is always an
    alternative paradigm. For example your query could include a column for
    rank e.g.

    SELECT T1.data_col, (
    SELECT COUNT(*)
    FROM Test6 AS T2
    WHERE T1.data_col >= T2.data_col
    ) AS rank
    FROM Test6 AS T1;

    Then you could do the 'paging' in your recordset e.g. using an ADO
    recordset's Filter property:

    rs.Filter = "rank > 0 AND rank <= 10"
    rs.Filter = "rank > 10 AND rank <= 20"
    etc.

    Jamie.

    --
     

Share This Page