Session Description

Procedures for creating your own reports using basic Aeries Query statements; single table queries, selection of data fields, sorting data fields, and constructing simple and multiple conditions.

Session Content

  • Aeries Tables & Fields
  • Accessing Query on the Aeries Web Navigation Tree
  • Features of the Query Form
  • Overview of Query Commands
  • Creating a Basic Query from STU Table
  • Query Datasheet Window
  • Including Inactive Students in Queries
  • Basic Troubleshooting of Query Errors
  • Query Conditions: IF, AND vs. OR
  • Creating additional Basic Query using one table (i.e., TCH, CRS)
  • Using Query Sort Command - BY
  • Saving & Loading Queries
  • Query Reports

Related Documentation

Query Overview

Table Structure

Beginning Query

Tables and Fields Icon

Query Save or Load

Query Report

Extended Student Fields for Query

Additional PDF documentation for this session is attached at the bottom of this article.

Related Videos

Query Overview Video

Query Fields and Functions Video

Query Sorting Video

Query Multiple Sorting Video

Query Simple Conditions Video