Results 1 to 2 of 2
  1. #1
    behnam is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2014
    Posts
    72

    How to order query records by date


    Hi all,

    I have a query, but i want to order the resullts by most recent on the bottom and oldest on top, based on date field called Time_of_Use, can someone give me an idea how, thanks.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    You can use an ORDER BY clause if the field is type date

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 07-04-2014, 12:29 AM
  2. Replies: 3
    Last Post: 03-11-2014, 07:32 PM
  3. Replies: 5
    Last Post: 12-12-2013, 12:14 PM
  4. Replies: 1
    Last Post: 05-09-2013, 09:13 AM
  5. Sorting a form's records in order by date.
    By slikbaz in forum Access
    Replies: 3
    Last Post: 11-20-2010, 01:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums