Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

transaction and account dates out of order

Discussion in 'Information Technology' started by Winnie, Jul 28, 2006.

  1. Winnie

    Winnie
    Expand Collapse
    Guest

    I enter transactions in Acces but in the individual
    account the dates are not in order.

    This has only just strted to happen.

    Can this be fixed please?
     
  2. Loading...

    Similar Threads Forum Date
    Ashdoc's Movie Review---The Accountant Theatre, Movies & Cinema Oct 21, 2016
    Events Banda Singh Bahadur's Martyrdom - An Eyewitness Account History of Sikhism Mar 26, 2015
    General Cricket Australia's twitter account just deleted this tweet about Monty Panesar Hard Talk Dec 5, 2013
    Heritage Rare account of Maharaja Ranjit Singh’s court up for auction in UK History of Sikhism Aug 27, 2013
    USA Whites Account for Under Half of Births in U.S. Breaking News May 17, 2012

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Winnie wrote:
    > I enter transactions in Acces but in the individual
    > account the dates are not in order.
    >
    > This has only just strted to happen.
    >
    > Can this be fixed please?


    Access does not store records in any specific order. If you want
    records to display in any specific order you need to tell Access how you
    want it sorted.

    You can sort on any field or even more than one field. So if you have
    an field (IAD) and if that date is a real data type field and not text, just
    sort on that field in a query, report or form and the records will appear in
    that order. You can further sort records from the same date by maybe the
    name of the individual.

    --
    Joseph Meehan

    Dia duit
     
  4. Wayne Morgan

    Wayne Morgan
    Expand Collapse
    Guest

    Where are you looking at them, in a table? If so, there is no guarantee that
    the records will be in any particular order in a table. To sort the records,
    use a query. You can also have a form or report sort the records that it
    displays.

    If you do a Compact and Repair, you may get some order back in the table,
    but as stated above, there is no guarantee. To do a Compact and Repair go to
    Tools|Database Utilities|Compact and Repair Database...

    --
    Wayne Morgan
    MS Access MVP


    "Winnie" <Winnie@discussions.microsoft.com> wrote in message
    news:6E5C1595-6350-445F-A36D-D2AD72AE953A@microsoft.com...
    >I enter transactions in Acces but in the individual
    > account the dates are not in order.
    >
    > This has only just strted to happen.
    >
    > Can this be fixed please?
    >
    >
     

Share This Page