Session Description

Multi-table queries, the "CHANGE" button and command; advanced applications of Query for elementary school personnel.


Session Content


  • Tips for complex queries
  • Advanced understanding of Aeries Tables Relations
  • Defining Multiple Tables & fields in a query
  • Use of the Database Table Information Report or Web Fields Doc
  • Building complex Query Statements
  • Sorting Data - Ascending or Descending Order
  • Aeries Query Commands vs. Access Query Commands
  • Selecting Records by Criteria “IF”
  • Using Connectives “AND” and “OR”
  • Math Operations within Query
  • Undo Last KEEP/SKIP
  • Change Button versus Change Command
  • Change Button with Multiple Tables
  • Advanced use of the Query Letter Editor
  • Creating & Customizing Advanced Query Labels or Envelopes
  • Troubleshooting of Query Errors


Query Tips

  1. Get a clear picture of what data is needed and the order that it should be sorted. If this data is a request, getting it in writing can be helpful.
  2. Identify the tables needed.
  3. Contemplate whether the query will be easier preceded with a KEEP or SKIP statement.
  4. What is the most logical order in which to place the fields?
  5. How should the data be sorted?
  6. Do I want to pass the data on to another application?
  7. Do I need to teach someone else how to do this query?  Share the load and make life easier for yourself and more rewarding for others.


User supplied queries can be found at the website http://www.aeries.com/training-support/queries under Queries.


Related Documentation


Aeries Table Relations

Database Table Information Report

Tables and Fields Icon

Database Definitions

Advanced Query

Advance Query - Elementary Examples

Query SKIP or KEEP

Query Change

Query Letter

Query Labels

Query Envelopes


Related Videos


Query Math Functions Video

Query Change Button Video