• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

How do I retrieve the previous and next rows in an Access database usng a query?

I have a database that lists a large amount of production jobs for the my company.  I order the rows by job number, but I was wondering how to accomplish this task with a query so I could end up putting all this information on a report.

What I want to do is grab the previous and next row's job number of the row that is currently populating the report.

For example, if I am looking at the report for job number 5, I want to put fields on the report that would list the previous and next job number in the database (maybe 4 and 6).  This is so the user knows where the jobs was and where it is headed.

What would be the best route to accomplish this task?

Thanks.
0
zrancidr
Asked:
zrancidr
1 Solution
 
Rey Obrero (Capricorn1)Commented:
see this link for several ways

http://support.microsoft.com/?kbid=210504
0
 
zrancidrAuthor Commented:
Looks like that has everything I could want.  Thanks for the quick answer!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now