Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2003
    Thanked 0 Times in 0 Posts

    Move Records (Access XP)

    Within a table, query or form I wish to be able to move the records up or down relative to the other records within the table, query or form.

    Any idea how I can do this.

    Many Thanks <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Move Records (Access XP)

    Hi Fruz,

    You can't really move records up or down. Records in an Access table are always stored in the order they were added to the table. But you can change the order in which they are displayed. The Sort Ascending and Sort Ascending buttons on the toolbar provide a quick way to sort a table, query or form on one field. The Records | Filter | Advanced Filter/Sort menu option allows you to specify a more sophisticated sort order. And when you are designing a query, you can specify the sort order in the query grid. If necessary, you can add columns to the query grid (bound to existing fields or calculated expressions) with the sole purpose of sorting the query.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 33 Times in 33 Posts

    Re: Move Records (Access XP)

    Access is not like Excel, it is a database. You actually don't even know the order the records are actually kept in the table; mostly because it is irrelevant. When you view the data, unless you specify what order you want, Access will makes it's own decision. Normally, it will present the data in the order based on the PrimaryKey field(s). To change the order, you can sort a table based on a column in datasheet view, or use the OrderBy clause in an SQL statement.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts