How to Create a Microsoft Access Form or Report From Filtered Records

You can create a Microsoft Access form or report from filtered records. For example, you might filter all records of a particular recording artist in your CD collection, and print a report based on those records only. These instructions are for Access 97.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Microsoft Access

1. Display the filtered records.

2. Click the little arrow on the right of the New Object button located on the toolbar. A menu of objects appears.

3. Click AutoForm or AutoReport.

4. Click either Form or Report, depending on which one you want to make.

5. Make any changes you want to the design.

6. Save your form or report.

Tips & Warnings

• The new form or report uses the table or query that was used when you created the filter. The filter is inherited.