Share this Page URL
Help

Chapter 5. Creating Data Reports > Creating an “Inverted” Search - Pg. 122

Creating Data Reports == Finds values that are an exact match for the total field contents, not just a part of the field 122 Creating an "Inverted" Search You probably know that you can omit records from an existing found set. However, you can also use the process of elimination to create a found set made up only of records that don't match the Find criteria. Imagine that you're projecting your average monthly sales for a bank loan. You don't necessarily want to include the month you closed up shop and snorkeled in the Bahamas, so you'd want to create a report that omitted that period from the found set. You can even create a single search that selects certain records and omits others. This combination lets you eliminate your vacation period while selecting only corporate purchase orders from the rest of the year's records. To omit records from a search 1. 2. 3. Switch to the layout you want to use for the search, then choose View > Find Mode (Control +F/Command+F). Enter the search criteria you want to eliminate from the found set in the appropriate fields. In the status area, check the Omit box (Figure 5.8), then click Find. Figure 5.8. Click the Omit box to exclude records from a search. The records that meet the search criteria will be omitted from the found set. In our example, the result would be a list of sales that excluded activity in the month of April. To select and omit at the same time 1. 2. Switch to the layout you want to use for the search, then choose View > Find Mode (Control +F/Command+F). Enter the search criteria for the records you want to find in the appropriate fields.