Filtering Records (Using the Wizards)

The Record Selection screen allows you to filter the fields that you selected earlier from the Fields screen. Record selection refers to the process of choosing the records to display within a report. In other words, record selection is a filtering process; you can have all records within a table display, or you can create a filter so that only a particular type of record displays.

For example, say you only want employee records from the Sales department to display within your report. Although an employee table contains employees from every department, a record selection statement will allow only employees from sales to display within your report. We discuss record selection further in Chapter 7.

The Record Selection screen allows you to control the records that your report should (or should not) display. Figure 4-10 (on the following page) displays the Record Selection screen.

Figure 4-10: The Record Selection screen (of the Standard Wizard)

You don't have to select records in this step; you can always filter your database fields after you're in the Report Design area. For now, just press the Next button.

Note

By not specifying any filters, you're stating that all records within your selected fields should display.