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.
The Field Conditions dialog box contains three main areas. These are:
- 3.7.1 The Operation Area
In this area you select a field in your query and specify the selection criteria you want to attach to it.
- 3.7.2 The Prompting Area
This area is used to specify that you want the query to pause so that you can enter selection criteria each time the query is run. For example, to specify the date or period for which you require a list of sales.
- 3.7.3 The Conditions Area
This is a list of the conditions that have been specified for the query in the sequence in which they will be processed by the host. Each item is treated as an individual search condition unless it is within brackets, in which case it is assumed to be in a "group" and is evaluated accordingly.
3.7.4 Add a Search Condition
3.7.5 Change a Search Condition
3.7.6 Delete a Search Condition