update next row

  • Thread starter Thread starter shank
  • Start date Start date
S

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!
 
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!
Click to expand...

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.
 
Back
Top