Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2007
    Posts
    5

    Unanswered: Sort in Report based on expression

    I am using Access 2010. I have a report linked to only one query. There is one header called "vendor name" which the records are grouped on. Also in this header, is an expression to sum the vendor dollar amount. Currently, the report sorted alphabetically by vendor. My intent is to sort the report by the sum of vendor dollar amount. Can anyone help?

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    Provided Answers: 2
    I use Access 2000 (still), but it seems to me that you need to change the "Vendor Name" header to a "Vendor Total" header.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    assuming you want to retain bith reports consider changing the sort order on the fly when you open the report based on a parameter either supplied as part of the call to open the report (the arguments bit of docmd.openreport) or pull the parameter from a form
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Jan 2007
    Posts
    5
    Imagine the report looks like this:
    ____________________________________________

    Vendor PO Number Vendor Amount

    ABC Industries $150,000
    PO1234567 $50,000
    PO9876543 $100,000

    XYZ Industries $250,000
    PO5433667 $150,000
    PO1321395 $100,000
    ____________________________________________

    The vendor name and total vendor quantity (the number to the right of the vendor name) are in the vendor header. The individual PO numbers with the associated individual vendor amounts are in the detail section.

    The problem: I do not understand how to sort the report by the total vendor amount. As you can see from the report above, the report is sorted alphabetically by vendor name. However, in this case, I want XYZ industries to appear at the top of the list because $250,000 is a greater number than $150,000.

    What other information can I provide to help you help me find an answer to this problem?

Posting Permissions

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