How do I subscript an index in Access?

A

AccessInTrouble

I want to retrieve and display the information forthe 8th, 7th and 6th prior
records after I have found the current record without knowing their primary
key. I thought I could do this using somthing similar to a table subscript.
I'm using Access 2003.
 
J

John Vinson

I want to retrieve and display the information forthe 8th, 7th and 6th prior
records after I have found the current record without knowing their primary
key. I thought I could do this using somthing similar to a table subscript.
I'm using Access 2003.
Click to expand...

An Access Table *has no subscripts and no record numbers*. The Table
should be viewed as an unordered "heap" of data; new records will
often be added at the end of the table, but you have NO guarantee of
that; they might be added in a gap within the table, or anywhere.

Unless you have some field or fields which define the order of records
that is meaningful to you, there is no way to do what you describe.


John W. Vinson[MVP]
 
Top