Create an invoice query using these steps:

1. In Query, click New.
2. Select Invoice as Query type, and Dynamic for Query format.
3. On the Criteria tab, expand 1099 Distribution, and double-click on 1099 Box Number. In the new window, select Operator not blank. Click OK.
4. If specifying a date range, Expand Invoice, and double-click on Invoice date. In the new window, enter the appropriate date range options. Click OK.
5. Add any appropriate fields to the Output tab of the query.
6. Run the query.