Hi Barb,

I don't know what you mean by "it does not read the <> setting".

Try copying this into your filter:
Code:
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.
_________________________
Andrew Bates