Using QMF

Adding conditions to the example table

You can write expressions in your example table that set conditions on which rows are selected. The query below selects only the rows where the commission is greater than or equal to 1000.

When you run this query:

Q.STAFF | ID | NAME | DEPT | JOB | YEARS | SALARY | COMM         |
--------+----+------+------+-----+-------+--------+--------------|
        | P. |      |      |     |       |        | >= 1000  P.  |

QMF produces this report:

   ID     COMM
-----  -------
   70  1152.00
   90  1386.70
  340  1285.00

Data types in conditions

If a column contains letters or special characters, it must have a character data type. (If it contains double-byte characters, it can have a graphic data type.)

If a column contains only numbers or mostly numbers, it might still have a character data type. For example, a column of part numbers might contain mostly digits. However, if a part number like "1390X" is in the column, the column must have a character data type.