Okay, I've got this Access database with one table that has 2 fields and an index, idxScore. All I want to do (at this point) is display the records from the table based on the index so that they will be in numerical order. I can get the records to display, but I can't seem to get them to index right.
The way I'm getting them to display is to loop through each record and whatever I find in there, I show on the screen. So I need to do the indexing before I start the looping, so they will display correctly.
I realize I could probably do a sql statement of some sort that would make everything order itself prettily, but then I don't know if that would make it harder/easier/about the same for my next step -- which is going to be to place a new high score in the table, delete the lowest old one and move down the others (whatever's lower than the new high score).
Thanks in advance for any and all help.
~~~~~~~~~~
Denise
~~~~~~~~~~