The following Filter will allow you to specify 2 Item Codes; one is the starting point and the other is the ending point. All Item codes between will be displayed (including the starting and ending codes).

AND(
{Item #} >= QUERYSTRING("Enter Starting Item Code"),
{Item #} <= QUERYSTRING("Enter Ending Item Code")
)

If you don't want a dynamic filter, do the following (where you would replace the 2 item codes with your own values).

AND(
{Item #} >= "BKHUNI001",
{Item #} <= "BKHUNI099"
)

Note that the Item Codes are unformatted. Do not include the hyphens, dashes or spaces that Adagio automatically inserts for you. For instance, Item BKH.UNI-001 would be specified as BKHUNI001.


Edited by Bruce Gardner (06/10/11 01:04 PM)