Searching in tables

When you search in tables, you can search directly for numeric values or text such as product numbers or company names, or look up values in related tables.

For direct searches, you can also use search operators to refine your search.
Operator Definition Example Comment
> Greater than "> 5" - greater than 5
>=

Greater than or equals "1.." - greater than or equals 1 (same as ">= 1")

">= 5" - greater than or equals 5
< Less than "< 5" - less than 5
<= Less than or equals "<= 5" - less than or equals 5 Can also be expressed "..5"
<> Not equal to "<>100" - not equal to 100 Can also be expressed "!=100"
| Or "1|2" - 1 or 2 Can also be expressed "1;2"
.. From - to "1..5" - from 1 to 5

See also: Looking up a value in another table

Learn more by visiting the Learning Universe (in Norwegian).