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
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