1. Create a vendor query and select the summary field Total payment Amount on the Ouput tab.  Select the proper payment date range or other filters.  Click Ok.
     
  2. On the Sort Tab, expand Summary and select the same Total Payment Amount field that was selected on the Criteria tab. Add the same date filters to field as you included on the Criteria tab. If the filters do not match, the query sort will be incorrect.
     
  3. Click Ok on the Edit Field Criteria screen and then click the Results tab.