Session Description

Query Tools will cover procedures for generating Reports, Letters, Labels, and Envelopes. The discussion will also include the Query Letter Editor, which allows you to create letters containing text plus data merged from a Query statement.


Session Content

  • Accessing Query on the Aeries Web Navigation Tree
  • Aeries Tables & Fields lookup
  • Create Excel spreadsheet
  • Creating Reports from Query Results
  • Creating & Customizing Query Labels
  • Creating & Customizing Envelopes
  • Creating Letters Using Query Letter Editor
  • Using Query Letter Option to Merge Fields into Letter
  • Change Function
  • Saving & Loading Queries
  • Reset
  • Access the Database Table Information Report
  • Overview of Extended Fields from Aeries Analytics


Related Documentation

Table Structure

Database Table Information Report

Tables and Fields Icon

Database Definitions

Intermediate Query

Query SKIP or KEEP

Query Save or Load

Query Report

Query Labels

Query Envelopes

Query Change

Query Extended Fields


Related Videos

Query Multiple Conditions Video

Query Complex Conditions Video