Hi Barb,
I don't know what you mean by "it does not read the <> setting".
Try copying this into your filter:
AND(
TRIM({Item #}) >= QUERYSTRING("Enter Starting Item Code","xxx"),
TRIM({Item #}) <= QUERYSTRING("Enter Ending Item Code","xxx"),
NOT(AND(TRIM({Item #})>="150822205",TRIM({Item #})<="150842962"))
)
Just highlight it directly from the forum post and ctrl-c copy it, then ctrl-v paste it into the Filter formula box.
Previous Topic
Index