A vendor query can report on a list of vendors and the total amount they were paid in a certain year.
1. Create a vendor query. 2. Do not select anything on the Criteria Tab. 3. On the Output tab, select Vendor, Vendor Name. 4. Select Summary, then double click on Total Payment Amount 5. Double click on Payment Date 6. Set the operator to equals and the date to Last Calendar Year or This Calendar year, then click ok. 7. Click Run.
Note: To sort the payment amounts from greatest to least, go to the Sort tab and select Summary, Total Payment Amount.