Performing operations on a subset of rows

Topic group

Sometimes you need to work with only a subset of the rows in a table. You can save time by selecting only the rows you want to work with, and avoid processing rows that don’t apply.

This group of topics explains how to

Select sets of rows to process

Count rows that meet a given set of criteria

Perform calculations on multiple rows

All of these features are found in the Table menu.

Many of the operations described in this section—including aggregate operations for calculating data, finding rows, filtering conditions, and linking parent and child tables—can also be performed by creating queries. For information, search the Help index for "SQL" or "queries."