3.9.4 Make a Query Based on More than One Criterion

This topic describes the systematic instruction to make a query based on more than one criterion.

Suppose you want to see loans (in the Loans module) based on more than one criterion - that is, you may want to see all USD loans with a value date (which come into effect) beyond 31 December 1999 and an interest rate greater than 10%.

1. To make such a query, first click on Currency under Fields, choose Equal To under Operator and USD under Value. Click Accept button. Now click AND button.
2. Repeat the procedure with the criteria value date and rate, click Accept button and AND button in the sequence described for the first criteria currency.
   You will see the query displayed in the Query screen.
3. Check it for correctness and click Ok button.
   You will see the LD Contract Summary screen showing only USD contracts with a value date beyond 31 December 1999 and a rate of interest over 10 per cent.