I had tried adding the SORT, but maybe I added it in the wrong place of the SQL statement. The sort would override the primary sort of Transactions.[Order].

I want to sort the query results by Transactions.[Order] first, then perform a secondary sort by [Sum of Amount].

for example this is an exampleof the data I get now:

Code:
Order     Transactions            [Sum of Amounts]
=====================================
  0         Applied Service Charge          (-425.00)
  0         Service Charge                      $500.00
 10        Installation Charge                  $125.00
 10        Applied Service Charge          (-101.25)
I want the query to return the data as such (Sort By Order,then Sort by [Sum of Amounts:] Descending, etc...

Code:
Order     Transactions            [Sum of Amounts]
=====================================
  0         Service Charge                      $500.00
  0         Applied Service Charge          (-425.00)
 10        Installation Charge                  $125.00
 10        Applied Service Charge          (-101.25)
I will try again placing the sort add theend as you suggested. Will post back. Thanks.