1 Reply Latest reply on Nov 24, 2010 8:04 AM by philmodjunk

    SCRAMBLED UP DATES

    khank

      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.

        • 1. Re: SCRAMBLED UP DATES
          philmodjunk

          Sounds like you are viewing your layout while in table view. In table view, unless you disable the feature, clicking a column heading sorts the records in ascending order on the first click and in descending order on the second.

          If you want to see your records displayed in a particular order you can either click a column heading (In table view only), or select Sort from the Records menu.