3.9.4 Making a Query Based on More than One Criterion

Suppose to view Letters of Credit based on multiple criteria, set the following in the Query screen:

• Currency as USD
• Value Date after 31 December 1999
• Interest Rate greater than 10%

Click OK, and the system displays the relevant records meeting all specified conditions.

To make such a query, first click Currency under Fields, select Equal To under Operator and USD under Value. Click Accept.

Now, click AND.

Repeat the procedure with the criteria value date and rate, click Accept and AND in the sequence described for the first criteria currency.

The query is displayed in the Query screen.

Check it for correctness and click OK. The LC Contract Summary screen displays only USD contracts with a value date beyond 31 December 1999 and a rate of interest over 10%.