Dennis, That did it! Thanks!! Mike
On Mar 18, 2012, at 6:27 PM, Dennis McGrath <[email protected]> wrote: > 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 >
