Metrohm 873 Biodiesel Rancimat Manual - Manual (Page 106)

4.7 Results ￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
98 ￭￭￭￭￭￭￭￭ 873 Biodiesel Rancimat
Criteria
Criteria for filtering data sets.
or
Further criteria for filtering data sets.
In the lines Criteria and or and in all following lines, data sets can be filtered
using expressions. An expression is a combination of operators, functions
and field names for determining a condition for filtering data sets. In the
following only the most important elements and rules are described and a
few selected examples are given. For more extensive information please refer
to the documentation on Microsoft Access.
Operators, functions,
field names Mathematical oper-
ators +, –, =, *, /
Comparison opera-
tors <, >, <>, <=, >=, Between…, And…
Logical operators AND, OR, NOT
Wildcards * (any character string), ? (single character), # (sin-
gle numeral)
Current date Date()
Current time Now() (date and time)
Other fields ["Field name"]
Links with various
fields If conditions are specified in various fields, these conditions can also be
linked with AND and OR. The following applies:
Criteria in the same line apply as AND conditions, i.e. only those data sets
are displayed which satisfy all conditions.
Criteria in various lines apply as OR conditions, i.e. all data sets which fulfill
one condition are displayed.
Examples > 10 Values greater than 10.
*oil* All data with "oil" as part of the name.
*2007* All data of the year 2007.
Between Date()
And (Date() - 7) All data of the previous week.