Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This command allows you to attach calculations to fields in your query, either before or after the query is run.

Select the Summary Options command or the Image Removed Image Added toolbar icon, to open the Summary Options dialog box.Image Removed

Image Added

You can add one or more of these options to each numeric field:

...

 
Each calculated result is inserted in the Results window as an additional row with its own label in place of the Row Number. These rows are inserted at the end of the Result as well as at the end of each group, if groups have been specified using the Group By command.

Image RemovedImage Added

Refer to LCE260 – Group, Summary and Sort options in the Tutorial for more details.