Type the following information into the Excel spreadsheet: The Show statements are: Close of NG, Close of CL. The When statements are: Date is after June 1, 1999 and NG is defined. When you are finished entering the data make sure you click back on the first entry. This cell designates the starting point for the data entries.

Select Show When from the MIM menu.

The Execute Show-When Query Server dialog box displays. The program automatically fills in the source and destination ranges based on where the data is entered on the spreadsheet.

If you want to change which data is selected, you can put your cursor in the Attr cells text box, go to the Excel spreadsheet and then select the desired cells in the spreadsheet. Another method for selecting data is to select the bar next to the destination cell then select the data from the spreadsheet. Using the button returns you to the Execute Show-When Query Server dialog box.

For Destination Ranges the program skips a row and then displays the data on the next row. The Num rows box has a default value of -1. When -1 is entered, all the data for the query will display. If you would like a certain number of rows of data to display enter a specific number.

For the Exec Units category, enter a value in the Num of Units box. The current default is 1. This field controls how often the data will display. For example, if this value was set to 5, every fifth day would display on the spreadsheet.

For the Units box, select a type of unit such as Years, Quarters, Months, Weeks, Days, Hours or Minutes. For our example select Days.

For the Options category, select a decimal place setting in the Decimal Place box.

Select OK to close this dialog box.

The Show When query will run and display in the designated target cells as shown below.

Clear the screen before proceeding to the next example.