How do I sort by "every other" or "every third" row/record?

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

Guest

I need a random sorting of 50 records for a specific person in a database
(identified by a 4 digit number). How do I get this or can I even do this?
Is it possible to sort by every other record or every third record?
 
I'm confused. You have "a specific person" with "50 records" in your table?

"Sort by" implies using some criteria to order a set of records. "Every
other" implies a selection criterion that eliminates records. Before you
can kick out "every other", Access needs to know how you want the records
ordered.

One approach might be to assign sequential numbers, AFTER you've determined
an order, then use the MOD function to help you pick every other or every
third or ...

Have you checked at Google.com or mvps.org/access on these topics?
 
Back
Top