Next Record In Table

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

Guest

I have a table with 3 main fields, Name, Date, Runs. I need to be able to
display the next record for a Name when Run = 1. Is this possible in a Query.
 
Hi,


NEXT record has to be defined through the data present in the record (such
as a date_time field), since in a table, records have no fixed POSITION. A
recordset, on the other hand, chain the records, one after the other, and
thus have a previous and a next record. A table, where the data is initially
stored, does NOT. A recordset may get its records ordered through the ORDER
BY clause of the statement use to "built it".


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top