Session Description

The "TOTAL", "KEEP", "SKIP" commands; printing labels, letters, saving and loading query statements, using "AND" or "OR", and multiple table queries at the secondary level.

Session Description

  • Access the Database Table Information Report
  • Creating a Single & Multiple Table Queries
  • Viewing and filtering the Query Datasheet View
  • Features of the Query Form
  • Using Special Characters in Queries
  • Overview of Query Commands including TOTAL, KEEP and SKIP
  • Use of the Query Letter Editor
  • Saving & Loading Queries
  • Creating Query Reports
  • Creating & Customizing Query Labels and Envelopes
  • Query Change
  • 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