 |
GreatManuals.com |
|
|
RecordSet Filter The RecordSet Filter Operation column shows up under the RecordSet Filter and Totals Filter tab. The Operation column pulldown box contains a list of the following values. Choose one of them and how it should "operate" based on the Field Description and Value for that row. See Operation column in the example below and how it is used with the Field Description and Value columns for the same row.
Note: You can use the ? column and [...] button for each row to help you enter values in the Value column. The value wizard type that opens up is based on the operator type in the Operation column.
Operation Pulldown Values: <Remove> - Removes operation from filter definition. Equals - Where a field/expression equals a certain value. Ex: [OrderDate] = #1/1/2000#. Less Than - Where a field/expression is less than a certain value. Ex: [OrderDate] < #1/1/2000#. Less Than of Equals - Where a field/expression is less than or equals a certain value. Ex: [OrderDate] <= #1/1/2000#. Greater Than - Where a field/expression is greater than a certain value. Ex: [OrderDate] > #1/1/2000#. Greater Than or Equals - Where a field/expression is greater than or equals a certain value. Ex: [OrderDate] >= #1/1/2000#. Does Not Equal - Where a field/expression does not equal a certain value. Ex: [OrderDate] <> #1/1/2000#. Is Null - Where a field/expression returns a blank value. Ex: [OrderDate] Is Null. Is Not Null - Where a field/expression is not a blank value. Ex: [OrderDate] Is Not Null. Between - Where a field/expression is between two values. Ex: [OrderDate] Between #1/1/2000# And #12/31/2000#. Has Values Of - Where a field/expression can only be one of several values in a list. Ex: [OrderDate] Has Values Of ( #1/1/2000# , #2/1/2000# , #3/1/2000# ). Not Values Of - Where a field/expression can NOT be several values in a list. Ex: [OrderDate] Not Values Of ( #1/1/2000# , #2/1/2000# , #3/1/2000# ). Like - Where a field/expression resembles a certain pattern. The following example returns values that begins with the letter S followed by any letter between B and S and then ends with two digits. Ex: [LastName] Like "S[B-S]##". The following example returns values that begin with the letter S followed by any letter that's NOT between B and S and then ends with two digits. Ex: [LastName] Like "S[!B-S]##". Contains - Where a field/expression can start with, end in or contains a certain value anywhere within it. Starts With - Where a field/expression starts with a certain value. Ends With - Where a field/expression ends with a certain value.
|
