Next item in line

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.

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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"OEB" wrote in message
...
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.

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" wrote:

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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"OEB" wrote in message
...
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.

Replies in-line.

"OEB" wrote in message
...
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.


"Allen Browne" wrote:

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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.