>Yes, I am trying to physically reorder the file so that my IDs are numerical order from top to bottom starting with 1 as the first ID at the top of the table.
It really does not make a difference what the underlying order of the records is... that's what an index is for. You don't want to have to do this all the time.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
