SCRAMBLED UP DATES
I have 1121 records.
Somehow my dates are descending in order mistakenly starting from ID #1 at 8/15/2010 to ID: #1038 Date: 10/2/2007.
Then correctly in ascending order picking up ID: # 1039 Date: 8/16/2010 to date.
Note: My ID numbers are correctly ascending in order. ID #1 should be 10/2/2007 and all dates should be descending in order to date.
The setup of those two field are:
1. The ID field is a "number" type, the options are Indexed, Auto-enter Serial, Always Validate, Numeric Only
2. The date field is a "date" type, the options is only Indexed.
Obviously, I probably didn't "click" something on to "lock" in the date and ID when I was first setting up the DB, it seems that everything is "loosy-goosey" from the field headings, if you mistakenly "click" a heading things get rearranged.
Could someone please help me.