update next row

[shank]

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!

 

[John W. Vinson]

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.