Specifies an item filter.

If the field contains an item number, the values in the quantity fields are only based on entries with the item number that is included in the filter.

You can enter a maximum of 20 characters, both numbers and letters. There are certain rules for how they should be entered:

Meaning Sample Expression Included

Equal to

1

Entries from item number 1. (The item number could contain letters instead of just numbers.)

Interval

1..5

Entries from item numbers 1 through 5.

Either/or

1|2

Entries that are from either item number 1 or item number 2.

Different from

<>1

Entries from all items except item number 1.

To see the item numbers in the No. table, click the field.

Tip

See Also