Results 1 to 5 of 5
  1. #1
    Mrdude1020 is offline Novice
    Windows 8 Access 2013
    Join Date
    Jul 2014
    Location
    Boone
    Posts
    11

    How to make dates appear newest on top on a report


    I have a messages database with a report for printing out the messages. But everytime i print them they show up oldest on top, and newest on the bottom. Is there a easy way to fix this?

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    yes, this is the Sort feature of Grouping & Sorting - which is an icon in the ribbon of the Report when in design view

  3. #3
    cbende2's Avatar
    cbende2 is offline Competent Performer
    Windows 7 32bit Access 2013
    Join Date
    Jun 2014
    Location
    Louisiana
    Posts
    370
    Yep, In the Control source for the report, Change whatever field your date is in to "descending" order.

  4. #4
    Mrdude1020 is offline Novice
    Windows 8 Access 2013
    Join Date
    Jul 2014
    Location
    Boone
    Posts
    11
    Awesome works great now. Thanks!

  5. #5
    cbende2's Avatar
    cbende2 is offline Competent Performer
    Windows 7 32bit Access 2013
    Join Date
    Jun 2014
    Location
    Louisiana
    Posts
    370
    You're welcome! Please mark thread as solved

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

Similar Threads

  1. Replies: 10
    Last Post: 08-29-2013, 09:21 PM
  2. how to get data with newest date
    By nubi3 in forum Queries
    Replies: 3
    Last Post: 04-30-2013, 12:14 PM
  3. Select newest Record
    By jbailey4545 in forum Queries
    Replies: 6
    Last Post: 06-22-2012, 01:58 PM
  4. Newest dates based on criteria
    By benjammin in forum Queries
    Replies: 13
    Last Post: 05-15-2012, 02:49 PM
  5. Aqtualization to the newest query
    By City73 in forum Queries
    Replies: 3
    Last Post: 10-30-2010, 07:18 PM

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