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...


  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