Mike Check the help for AUTONUM, it has an ORDER BY option
Dennis McGrath [email protected] [email protected] On Sun, Mar 18, 2012 at 5:01 PM, Michael J. Sinclair <[email protected]>wrote: > 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 >
