I have a report that will print out 50+ pages. When I add one record that starts with A in my alphabetically listed report I would like to only print the records that start with A, in order to save pages. Is this possible. Thanks to all.
Build a query for it. In the design view of the query, go to the field which contains the name/item of interest. In that column, go down to the "Criteria" row and type A*
If you go to the "Sort" row, you can click on "Ascending" and it'll sort in ascending order.
Once you've done this, click on exclamation point in the toolbar or go to the menu bar and click on "Query" and "Run."
Once the query is run and saved, you can build a report based on that query.