Query Wizard: Step 4a – Limit Records

You can further limit the number of records in the view, based on either a percent of the records returned, or an actual number of records. For example, to see the top 10 items, choose Number of records and enter 10 in the Portion value box. Choose Preview to see the records returned based on the imposed limit.

See Also

Cross-Tab Wizard | Local View Wizard | Query Wizard: Step 1 - Select Fields | Query Wizard: Step 2 - Relate Tables | Query Wizard: Step 2a - Include Records | Query Wizard: Step 3 - Filter Records | Query Wizard: Step 4 - Sort Records | Query Wizard: Step 5 - Finish | Remote View Wizard | Query Wizard