Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2014

    Exclamation Unanswered: report - sort by calculated field

    I have a report to accumulate monthly costs per machine. I list all invoices per machine with invoice amount, then total per machine for that month with a calculated field in the 'Machine' footer. Can this report be sorted by the monthly total of invoices (the calculated field)?

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    Create a query with the computed column included in it, then select that column for sorting the report.
    Have a nice day!

Posting Permissions

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