The following table describes the columns in the Specify Record Selection display. Table34.SpecifyRecordSelectiondisplayfields Chapter 10. Work with PFD Definitions 185 Column Description AND/OR AND and OR are the only values that you can specify in the AND/OR column. If this column is left blank and the other three columns (Field, Test and Value) in the same line are specified, AND is assumed. If AND and OR are specified together, AND is evaluated before OR. For example, YEAR EQ 1990 AND MONTH RANGE 11 12 OR YEAR EQ 1991 AND MONTH RANGE 1 2 means the period from November, 1990 through February, 1991. Field Any fields of the input record format in the input database file can be specified. You can list all fields in the database file by pressing the F4 key after positioning the cursor in this column. Test Test is the logical condition for data selection. One of the following can be specified: EQ Test is positive when the content of the field is equal to the value. For example, PRICE EQ 200 Records are selected if the field PRICE contains a value of 200. NE Test is positive when the content of the field is not equal to the value. LE Test is positive when the content of the field is less than or equal to the value. GE Test is positive when the content of the field is greater than or equal to the value. LT Test is positive when the content of the field is less than the value. GT Test is positive when the content of the field is greater than the value. RANGE Test is positive when the content of the field is between or equal to one of the two values. PRICE RANGE 100 300 Records are selected if the field PRICE contains a value between 100 and 300. This the same as the following: PRICE GE 100 AND LE 300