Next item in line

[OEB]

I am not sure how to really explain this, but here is what I need. I have a
list of items that are in chronological order listing the stages a project
goes through. I need to create a query that shows the next item in the
sequence.

I tried to add a 1 to the id number, but obviously that only gives me a
number. How to I get the stage, or level, assigned to that number in the
table?

I appreciate any help you can give me.

 

[Allen Browne]

Use a subquery to get the value from another record in the same table.

Details:
http://allenbrowne.com/subquery-01.html#AnotherRecord

 

[OEB]

Thanks. I am not very clever at this and I have some questions. First, is
this another query altogether? Second I am using the Query design, not SQL
view, so where do I put that example information? Sorry to be so stupid : )

 

[Allen Browne]

Replies in-line.

First, is this another query altogether?

No: it is part of the same query, not another one.

Second I am using the Query design, not SQL view,
so where do I put that example information?

Choose SQL View in the View menu.
Put the information into the SQL statement.