Skip to main content

By

Syntax​

By                  field_name

Parameters​

  • field_name: The name of the field to group by (e.g., STATE, TSHIRT).

Description​

Sorts and groups a listing by a specified field, adding a header at the start of each new group.

Remarks​

This is similar to Sort but adds group headers (e.g., "STATE = NY"). It's useful for breaking results into sections. When used without any Field or Event commands, it acts as a quick tally, counting the entries in each group. Use Records/Page with a large number for multi-page By reports to prevent awkward page breaks.

Examples​

To group all entrants by state and sort by last name within each state:

By                  STATE
Sort                LAST NAME
Records/Page        2000

To get a simple tally of T-shirt sizes:

By                  TSHIRT