Session Description

This session will build on the concepts introduced in the Basics of Query session. Topics in Intermediate Query will include using the “TOTAL”, “KEEP”, and “SKIP” commands; saving and loading query statements, using “AND” or “OR”, and multiple table queries at the elementary or secondary level. This session is intended for the Aeries user who has attended Basics of Query.

Session Content

  • Accessing Query on the Aeries Web Navigation Tree
  • Aeries Tables & Fields
  • Access the Database Table Information Report
  • Features of the Query Form 
  • Overview of Query Commands including TOTAL, KEEP and SKIP
  • Using Special Characters in Queries
  • Creating a Single & Multiple Table Queries
  • Viewing and filtering Query Results
  • Creating Query Reports
  • Saving & Loading Queries
  • Troubleshooting of Query Errors

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

Additional Documentation