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
Database Table Information Report
Related Videos
Query Multiple Conditions Video
Query Complex Conditions Video