How to use Ad Hoc query
The Ad hoc query tool allows you to retrieve exactly the information you want from the MIS. Follow these steps.
Select Ad hoc query from the Main Menu.
Select one of the forms from the list. The list consists of all the forms that have published data, and will change from time to time as data is published.
Choose the columns you wish to query by checking the box. If you wish to limit the selection, enter the criteria in the input boxes. In setting the criteria, you may use the abbreviation in the 'Abbr' column (with the square brackets) in your comparisons or any numeric expression. When done, click the Run Query button at the bottom of the screen.
The MIS will display all the data that meets the criteria you entered. You will then have the options to Format for printing or to Save to MS Excel.