Hi Team,

I am writing a view to select the items below from a table, is there another way to arbitrarily select multiple items from a database instead of using "OR". My past experience that work well was for say 2 - 4 items but now I am not finding all records in the Filter of 21 items...??

Any HELP welcomed...

One Love...

Edward.

Actual Filter in use:

AND(
{Station}= 1
,
{Line Type} = 2
,
OR (
TRIM ({Item #}) = "AA0301",
TRIM ({Item #}) = "AB0071",
TRIM ({Item #}) = "AC0041",
TRIM ({Item #}) = "AD0001",
TRIM ({Item #}) = "AE0045",
TRIM ({Item #}) = "AF0001",
TRIM ({Item #}) = "AG0003",
TRIM ({Item #}) = "AH0006",
TRIM ({Item #}) = "AI0011",
TRIM ({Item #}) = "AJ0701",
TRIM ({Item #}) = "AK0041",
TRIM ({Item #}) = "AL0201",
TRIM ({Item #}) = "AM0301",
TRIM ({Item #}) = "AN7001",
TRIM ({Item #}) = "AP0081",
TRIM ({Item #}) = "AQ0901",
TRIM ({Item #}) = "AR5001",
TRIM ({Item #}) = "AS0091",
TRIM ({Item #}) = "AT0011",
TRIM ({Item #}) = "AU0601",
TRIM ({Item #}) = "AZ0101"

)
,
{Date} >= Querydate("Enter Start Date YYYYMMDD", DATE(2022,06,01))
,
{Date} <= Querydate("Enter End Date YYYYMMDD", DATE(2022,06,30))
)