AnsweredAssumed Answered

SCRAMBLED UP DATES

Question asked by khank on Nov 24, 2010
Latest reply on Nov 24, 2010 by philmodjunk

Title

SCRAMBLED UP DATES

Post

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.

Outcomes