using next and previous record information in a report

  • Thread starter Thread starter MaryT
  • Start date Start date
M

MaryT

I want to print a report that lists information about a
current record, previous record and the next record I
have in a query. How do you do this?
 
The only reliable method that I am aware of is to do this in a query. You
can use subqueries to get a value from the next and previous records. There
has to be some values in the table that describe the sort order.
 
Back
Top