Create a quick report for a filtered table in Access

by Mary Ann Richardson | May 29, 2007 7:00:00 AM

Tags: Microsoft Office, Databases, Mary Ann Richardson, Click Yes, AutoReport, Microsoft Access, Microsoft Office Suite Access Tips Newsletter

Takeaway: Access' table filtering tools are handy, but they can be unwieldy and produce results that look unprofessional. Here's how to use AutoReport to create sharp and specific records based on the data of your choice.

For your benefits meeting tomorrow, you need a report that lists the records for all clients who reside in New York City. You can quickly obtain those records using Access' table filtering tools; however, you probably don't want to bring a printout of the resulting datasheet to your meeting. Instead, give your report a more professional look with AutoReport. Follow these steps:

1. In the Database Window, click Tables under Objects, and then double-click the Customers table.
2. Click any record field in the City column containing New York.
3. Right-click the field and choose Filter By Selection.
4. Click the New Object button and choose AutoReport.
5. Click Yes.
6. Click the Close button on the Report window.
7. Click Yes.
8. Give the report a name and then click OK.
9. Click the Remove Filter button in the Table toolbar before closing the table.

AutoReport shows only the records for the customers in New York City. You can edit, save, and print it like any other report.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring