Entering Selection Values for OIW Queries
You are not restricted to entering single values in selection cells, but you can also specify a set of selection values for
Selections:
Enter: |
Query refers to: |
ABC as selection for material |
material ABC |
A* as selection for material |
all materials that begin with A |
1000,1001 for plant |
plants 1000 and 1001 |
100*,2001..2005 for plant |
all plants that begin with 100, and also the plants 2001 to 2005 |
7.94..12.94 for period |
July to December 1994 |
1000.. for sales (in a query on customers) |
only the customers whose business was worth $1000 or more |
>1000 for sales (in a query on customers) |
only the customers whose business was worth more than $1000 |
Please note that for delimiting multiple selections (i.e. instead of the comma in the above examples), Excel’s standard list delimiter must be used. This delimiter may depend on the language dependent settings of Windows.
When entering data into selection cells you should keep in mind that Excel automatically converts certain data formats. Leading zeros are normally removed from numeric input. If you want to prevent this happening, you can enter an apostrophe immediately before the numeric data. You would have to enter ‘0099 in order to refer to the plant 0099, for example.
You should also note that the relationships between selection cells and queries can become extremely complex, especially if there are several queries defined on the same worksheet. For example, it is quite possible for a selection cell to affect several queries simultaneously. In complex situations you should use the Show relationships function to examine the various interdependencies (see also
Creating and Displaying Relationships in Queries).