MY GRID SHOWS ALL MY RECORD IN THE ORDER THEY WERE ENTERED. ID LIKE TO SHOW THE MOST RECENT RECORDS FIRS, AND THEN DESCEND TO THE OLDER RECORDS, BASICALLY ,i WANT TO FLIP THE ORDER THE RECORDS ARE DISPLAYED. HOW DO I DO THIS?
Printable View
MY GRID SHOWS ALL MY RECORD IN THE ORDER THEY WERE ENTERED. ID LIKE TO SHOW THE MOST RECENT RECORDS FIRS, AND THEN DESCEND TO THE OLDER RECORDS, BASICALLY ,i WANT TO FLIP THE ORDER THE RECORDS ARE DISPLAYED. HOW DO I DO THIS?
Pete,
The only way to do this would be if your records had a sequence number or Timestamp that increased for every record. Then set:
dbSQL = "Select * from YourTableName Order By TIME_FIELD DESC" or
dbSQL = "Select * from YourTableName Order By ID DESC"
Do you have such a field? You'll need one!
Mark.
------------
Pete Dumont at 1/11/00 9:55:53 AM
MY GRID SHOWS ALL MY RECORD IN THE ORDER THEY WERE ENTERED. ID LIKE TO SHOW THE MOST RECENT RECORDS FIRS, AND THEN DESCEND TO THE OLDER RECORDS, BASICALLY ,i WANT TO FLIP THE ORDER THE RECORDS ARE DISPLAYED. HOW DO I DO THIS?