Selecting Records

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I need to create a query that will return records from a
table, but this records will be selected based in the
position on the table, for example every 10th record in
the table. Has anybody created a query like this one? or
maybe using a sub to get the data?
 
There is not a 10th or 20th record since records in a table have no specific
order. You could probably select 10% of the records that are ordered by a
random value.
 
try adding an autonumbered field, then query that field
with an "ends with 1" criteria. should result in 1, 11,
21, etc.
 
Back
Top