G
Guest
I am trying to build criteria in order to filter out several things. I want
all inventory items that have been used since 1/1/2002 or have a "y-t-d"
(year-to-date) sale or have an "on hand" quantity. If they qualify for any of
these I want it in the query.
What I have right now:
Like [Correlation Part #'s - Dallas]![LAST ACTI]>1/1/2002 Or Like
[Correlation Part #'s - Dallas]![Y-T-D UNITS S]>0 Or Like [Correlation Part
#'s - Dallas]![ON HAND QUAN]>0
all inventory items that have been used since 1/1/2002 or have a "y-t-d"
(year-to-date) sale or have an "on hand" quantity. If they qualify for any of
these I want it in the query.
What I have right now:
Like [Correlation Part #'s - Dallas]![LAST ACTI]>1/1/2002 Or Like
[Correlation Part #'s - Dallas]![Y-T-D UNITS S]>0 Or Like [Correlation Part
#'s - Dallas]![ON HAND QUAN]>0