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.