Need help to write query to show records by record number

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

Guest

Hello,

I have an access table which has 24,000 rows. What I would like to do is
have four queries to to show records in four parts.

That is, the first query would show the first 6000 records, the second query
would show 6001 to 12000 records, third query show 12001 to 18000 records and
the fourth query show 18001 to 24000 records.

Please help and provide the necessary SQL or Query builder syntax to write
these queries.

Much appreciated.

BM
 
Is this a trick question? I mean are you hell bent on returning 6000 records
each time
or would you be satisfied with say all records with record numbers between 0
and 6000 even if deletions
cause the record count to be say just for example 5973 records.
Cause I would just enter criteria in the record # column of the query like:
<6000
or
6000 and <12000
Click to expand...
if it was me.


Ed G
 
Access stores data in tables, in whatever order IT decides. When you say
"the first 6000 records", what are you using to sort/order?
 
Back
Top