Page 56 - TP_Prime_V2.2_Class8
P. 56
Creating a Query
To create a query, follow these steps:
Step 1: Click on Query Design command from Queries group under Create tab.
Prime (Ver. 2.2)-VIII Step 2: The Show Table dialog box will open. Select the desired table and click on the
Creating a Query
Add button.
Step 3: Add the field's name to the query window and specify the criteria.
54
Defining Query Criteria
The parameters of the design grid in the bottom part of the Query window are:
• Field: It displays the selected field names from the table or query.
• Table: It displays the name of the existing tables in the relationship window.
• Show: This means that the field with the check mark will be displayed in the result and
the fields with an uncheck mark will not be displayed when the query runs.
• Sort: It displays the data in either descending or ascending order during the run
time.
• Criteria: This displays the condition on the basis of which the records will be filtered
and displayed in the query output.
• Or: It is used to set multiple conditions in a query.
After creating the query, we need to run the query by clicking on the Run button .
The related records of the query will be displayed in the Datasheet view.

