Selecting every nth row

Results 1 to 2 of 2

Thread: Selecting every nth row

  1. #1
    Join Date
    Dec 1969

    Default Selecting every nth row

    I&#039m trying create a Make-Table Query which sorts a table on a non-key field, then selects every fourth row from the table.<BR><BR>The table is in Access 2000 and will be used on an ASP web page.<BR><BR>Any ideas?<BR><BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: Selecting every nth row

    If your table isn&#039t going to be too big, you can grab the entire contents of the table and then use the .Move method of the Recordset object to move four records through at a time.

Posting Permissions

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