Analyzing with Advanced Selection Criteria
Creating a simple report is as quick as choosing tables, dragging and dropping fields on the report, and clicking the Preview button. However, if you perform only those few steps, you may have a much larger report show up than you bargained for! One important step missing is record selection. If you don’t enter some record selection criteria, every record that exists in the tables you choose will appear on the report.
In the case of a small PC-type database with, say, 1,000 records, this won’t be terribly time- or resource-intensive. However, if you’re connected to a large SQL database with potentially millions of records, the consequences of not including record selection will probably be ...