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

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. 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.

Check it for correctness and click ‘Ok’ button. You will see the ‘LC Contract Summary’ screen showing only USD contracts with a value date beyond 31 December 1999 and a rate of interest over 10 per cent.