Can one of you very kind people help me please
I need to amend a query to cover the following
from ordr
if CardCode = C000111 and
from rdr1
ItemCode = CHSE040 then hide or do not display item in history list
thats what im trying to achieve, but im confused by the current query, I can include this code if you wish