Results 1 to 6 of 6

Thread: Record Sorting

  1. #1
    Join Date
    Oct 2007
    Posts
    214

    Question Unanswered: Record Sorting

    Hi All,

    How would one go about sorting records on a form load or current in ascending order by a field called Date_Modified? Thanks!

  2. #2
    Join Date
    Mar 2009
    Posts
    5,441
    Provided Answers: 14
    Have a look at the OrderBy property of the form.
    Have a nice day!

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    set an index on that column
    then as Sindndho says set the order by property of the form
    OR
    set the query of the form to include an ORDERBY clause
    eg
    Code:
    SELECT my, column, list FROM mytable
    ORDER BY Date_Modified
    or
    if you want to have different orders at different times use a radio button group, when each button is pressed set an order by based on the appropriate radio button value
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Oct 2007
    Posts
    214
    This really slows things down when I initially open the form. Is there anyway to speed it up? Did some research and I can't seem to find a solution. Thanks .

  5. #5
    Join Date
    Mar 2009
    Posts
    5,441
    Provided Answers: 14
    Quote Originally Posted by benz1984 View Post
    This really slows things down when I initially open the form. Is there anyway to speed it up? Did some research and I can't seem to find a solution. Thanks .
    You can't have everything for nothing. You could try to create an index on Date_Modified.
    Have a nice day!

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if you only ever want to see rows in Date_Modified order then set that as part of a query for the form

    select all the column for the tabel and add an order by and then use that query as the underlying rowsource for the forms

    SELECT my, column, list FROM mytable
    ORDER BY Date_Modified
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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