1. Create a new vendor query
  2. On the Criteria tab, expand Summary and double-click Invoice Count.

    Query-Invoice Count

    • To find vendors with no invoices after a specific date:
      Select equals from the Operator drop-down list and enter 0 in the Value field
       
    • To find vendors with any invoices after a specific date:
      Select greater than from the Operator drop-down list and enter 0 in the Value field.
     
  3. Select the Filter tab and select Invoice Date in the Available fields frame.
     
  4. Select greater than from the Operator drop-down menu. Select <Specific Date> in the Date field and enter the appropriate start date in the Value field.

    Query-Invoice Count


     
  5. Click OK, and then click OK again.
     
  6. On the Output tab, select the appropriate fields to show in the query results (e.g. Vendor Name).
     
  7. On the Sort tab, sort the results in the appropriate order.
     
  8. Select File, Save from the menu bar to save the query.
     
  9. Select the Results tab to view the results.
     
  10. Print or export the query.