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
|
|||
|
|||
update next row
I need to update a field in a table I use for grooming data.
Something like... IIF (Row1.PO=Row2.PO,Row1.InvNo,Row1.InvNo+1) ....and it would loop through all rows and stop at last row How do I accomplish that with an UPDATE query? After update, data gets exported then deleted. thanks! |
#2
|
|||
|
|||
update next row
On Wed, 2 Dec 2009 21:47:15 -0500, "shank" wrote:
I need to update a field in a table I use for grooming data. Something like... IIF (Row1.PO=Row2.PO,Row1.InvNo,Row1.InvNo+1) ...and it would loop through all rows and stop at last row How do I accomplish that with an UPDATE query? After update, data gets exported then deleted. thanks! You don't, because - unlike a spreadsheet - tables have no row numbers and no defined order of records. Please explain the structure of the table. A Self Join query may be the solution. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|