This folder contains 16 articles

Query

These articles explain how to use the Query to create customized lists and reports of data.

Query Change
Change Button versus CHANGE Command Aeries Query provides two methods to quickly change data in a table, the Change button and the Change command. The idea...

Fri, Feb 23, 2018 at 2:57 PM

Query SKIP or KEEP
The SKIP and KEEP commands are used to create temporary filters on the STU table that will only contain students meeting certain criteria such as a particul...

Sat, Feb 10, 2018 at 1:59 AM

Query Save or Load
Save Query Statements Once a query statement has been created and generated it can be saved and accessed for later use.  It is suggested that only queri...

Sat, Feb 10, 2018 at 12:43 AM

Advanced Query - Elementary Examples
Selecting Records by Criteria Criteria to select only certain records for the query results is added to the end of the query statement. The IF command a...

Wed, Jul 13, 2022 at 5:07 AM

Advanced Query - Secondary Examples
Selecting Records by Criteria Flex Queries:  If a query needs a conversion for Flex Scheduling, it is displayed in below the original query in blue. ...

Wed, Jul 13, 2022 at 5:09 AM

Extended Student Fields for Query
  Overview  Security  Using Extended Student Fields in Query  Configuration     Overview  Extended Student Fields is a powerful feature of Aeries Que...

Tue, Sep 21, 2021 at 11:28 AM