Hi All, I have a table with a few thousand rows. The first column is an integer and initially it has no data. That is the column I want to use to number my rows. I want to put a 1 in the column for the row that has the lowest value for the 2nd, 3rd and 4th columns. They all have data that is easy to sort (date, time and filename). At the moment, what I am doing (which works just fine) is I declare a cursor to go through the table, ordered by the date, time and filename, and update the integer column with a number (.vcount +1). Is there a better way to do this? Should I be using a project command with an order by clause and an autonumbered column? What is the fastest way to autonumber a column based on the sort order of other columns? Mike
