3.7 Select Only Specific Data

The Field Conditions command allows you to select only the data that you require. For example, you may wish to obtain a list of employees who have commenced employment after a particular date or to find all customers with names commencing with the letters A through to E.

Because you only retrieve the data you require from the host, this command can only be used when you are defining your query in the Query window.

When you select this command from the Options menu or via this toolbar icon, the Field Conditions dialog box appears.

Enter the

The Field Conditions dialog box contains three main areas. These are:

Further Information

3.7.4 Add a Search Condition

3.7.5 Change a Search Condition

3.7.6 Delete a Search Condition