<% @language=VBScript %> Database Elements, Queries
Corporate View

 

Introduction
Table, Records, and Fields
Forms
Filters
Queries
Reports

Database Elements
Page 5 of 6

Queries

A query finds records in a database according to criteria you specify. Sometimes working with all the data in a large database is not practical. You might wish to work with just a small part or subset of the data. For example, you might want to find records for unresolved customer support incidents. A query can be used to display these records. You could construct the query to display only selected fields, such as Log ID and Resolved. A query displays only the data you request.

The table in Figure 9 shows all data that has been entered in the database. An empty checkbox in the Resolved field indicates the incident has not been resolved.


Figure 9 Table Displaying All Data

Figure 10 shows the results of a query. Only the Log ID and Resolved fields for unresolved incidents are displayed.


Figure 10 Data From a Query

Page 5 of 6