Results 1 to 4 of 4
  1. #1
    nashr1928 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    146

    report page date

    I have a report that has 332 pages that reflect a main form that has 332 records. I open the report and the pages do not show in order by latest date of latest record. I changed the table and the query to sort ascending but the report looks the same. What am I doing wrong?

  2. #2
    PrintShopSup is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    11
    If I read your question correctly, you are trying to get the most recent date first. I believe that the query sort would be decending instead of ascending...

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    For a report, you need to set up the sort you want in View/Sorting and Grouping.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    nashr1928 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    146

    report page date

    I went ahead and sorted the date fields in the report. This worked fine. Before I had mistakenly selected the wrong field. Your suggestion works perfect. Thank you for your assistance.

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

Similar Threads

  1. Page break on report inserts empty page between
    By Galadrielle in forum Reports
    Replies: 0
    Last Post: 07-07-2010, 04:18 AM
  2. Replies: 1
    Last Post: 05-22-2010, 08:30 PM
  3. Report Page Setup
    By DaniC818 in forum Reports
    Replies: 1
    Last Post: 03-30-2009, 07:33 PM
  4. Replies: 0
    Last Post: 02-26-2009, 03:34 PM
  5. report prints blank page at end of report
    By darrellx in forum Forms
    Replies: 0
    Last Post: 03-14-2006, 08:51 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