selecting rows using sql statement

F

Feng

Hi, suppose I have added an index to an Access database. Is there anyway I can get the first 500 records or records 501 to 1000 or 1001 to 1500 of this database sorted using this index. Is there a sql statement that does this. I notice that in Access, when I move up and down, there is a tracker of the record number. Is it possible that I can use this as a field?

Thanks
Feng
 
V

Van T. Dinh

Check JET SQL Reference section (of Access Help) on the
TOP predicate.

No, you cannot use the CurrentRecord number since this
number is not available until Records are selected!

HTH
Van T. Dinh
MVP (Access)


-----Original Message-----
Hi, suppose I have added an index to an Access database.
Click to expand...
Is there anyway I can get the first 500 records or records
501 to 1000 or 1001 to 1500 of this database sorted using
this index. Is there a sql statement that does this. I
notice that in Access, when I move up and down, there is a
tracker of the record number. Is it possible that I can
use this as a field?
 

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

Losing SQL Indexes when linking into Access 2000 0
Return query records in groups of 500 1
question on Access 2007 datasheet filter 1
UPDATE Query 2
Execute SQL 1
SQL Server Backend is Read Only 7
Drop a table before creation in SQL? 8
In data range select final value. 2

Top