Results 1 to 3 of 3
  1. #1
    BatmanMR287 is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Jan 2014
    Posts
    69

    decending order sub-report


    I have a query that returns six totals. The problem is I need to display each total vertically from largest to least. If they were in the same column I could easy do this. Since they are not I don't know how to make a sub-report that shows them vertically from largest to least. The totals will change depending on the district so it has to be able to sort itself for the report.
    All tables are a relational database. There isn't a way to change any internal structure.
    Any ideas?

  2. #2
    BatmanMR287 is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Jan 2014
    Posts
    69
    Nevermind. I found a way to populate a temp table perfectly so they are all in the same column and can be filtered and printed correctly.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Should be able to accomplish with a UNION query as the subreport RecordSource. Why are these totals in 6 fields instead of 1?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Report in alpha order
    By khartoum in forum Reports
    Replies: 12
    Last Post: 03-27-2012, 09:01 AM
  2. Report in calendar order
    By khartoum in forum Access
    Replies: 5
    Last Post: 03-27-2012, 02:45 AM
  3. Order Report by Textbox Value
    By alyon in forum Access
    Replies: 6
    Last Post: 07-29-2011, 11:10 AM
  4. Order Summary Report
    By ryonker in forum Reports
    Replies: 1
    Last Post: 01-10-2011, 09:15 PM
  5. Purchase Order Report
    By jordanturner in forum Forms
    Replies: 1
    Last Post: 10-13-2010, 10:53 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