If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Next item in line
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. |
#3
|
|||
|
|||
Next item in line
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. |
#4
|
|||
|
|||
Next item in line
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. |
Thread Tools | |
Display Modes | |
|
|