selecting rows using sql statement

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

Guest

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
 
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?
 
Back
Top