D
Debbie S.
I am trying to exclude text data that originates in a lookup field in the
table, in a query (in other words there are about 6 things in the lookup and
I want to design a query that will only contain 3 or 4 of the values in the
lookup). I have tried:
"x"; "y"; "z" in the criteria line of the query design as well as
"x"&"y"&"z" and x&y&z
Nothing is working. I can include or exclude one value alone[such as: <>x or
"x"], but it refuses to accept more than one. I know there is a way to
include or exclude more than one criteria in a query. What am I doing wrong?
Thank you.
Debbie
table, in a query (in other words there are about 6 things in the lookup and
I want to design a query that will only contain 3 or 4 of the values in the
lookup). I have tried:
"x"; "y"; "z" in the criteria line of the query design as well as
"x"&"y"&"z" and x&y&z
Nothing is working. I can include or exclude one value alone[such as: <>x or
"x"], but it refuses to accept more than one. I know there is a way to
include or exclude more than one criteria in a query. What am I doing wrong?
Thank you.
Debbie