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!