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.
 
You must log in or register to reply here.

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

Unlimited field size in Access 2007 reports 2
Printing the current record 1
counting records 0
Putting all record information in one column/field on report 1
Diary report 4
Grouping records per sheet 1
Query design 0
Saving page number from report 5

Back
Top