Specifying output fields to display

You will display the AccountNumber, TransactionType, Date, and Units in the answer table.

You can display the content of specific fields in the answer table. In the procedures below, you will learn how to display field information and how to display specific criteria to appear in the answer table without having the entire field appear in the Answer table.

Specify output fields

• In the query window, enable the check boxes corresponding to the AccountNumber, Transaction Type, Date, and Units fields.
  This is what your query should look like once the checks have been added.

Specify result criteria

1. In the query window, click the gray area of the AccountNumber area until a cursor appears.
2. Type 12365.
   Only records that have the account number 12365 will appear in the answer table.
3. Click the gray area of the Company area until a flashing cursor appears.
4. Type Company A.
   By doing this, this means that only records that have the company name "Company A" will appear in the answer table, and since the check box for Company is not enabled, this field will not be included in the Answer table.
   This is what your query should now look like.

Continue