Return every nth record? - newbie

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.

I am trying to get a result of returning every 4th record in a database of
thousands.

Not sure how to go about the process?
 
In order for "every 4th record" to be meaningful, you must have a primary
key that defines uniquely defines the order of records.

For this example, we will assume it is an AutoNumber named ID, and the table
is named Table1.

You could get a counter in your query by typing a subquery such as this into
a fresh column of the Field row in query design:
(SELECT Count(ID) FROM Table1 AS Dupe WHERE Dupe.ID <= Table1.ID)

To get every 4th record, use Mod 4. The expression in the Field row is
therefore:
(SELECT Count(ID) FROM Table1 AS Dupe WHERE Dupe.ID <= Table1.ID) Mod 4
In the Criteria row, enter:
0
Uncheck the Show box in query design. (Results will be read-only if you do
not clear this box.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

select every nth record 1
Pull every Nth record based on starting value 5
Sum of every nth cell in a column 3
Why does MSAccess cut query after 2886000 records 1
Access 2000 append unbound text box values to a table 0
not in criteria fails 2
Tablet size: I love the 8 inches 1
Records with null values aren't being returned 5

Back
Top