criteria question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to omit a given value (text string) of a queried table field in
a query. I know that to query a desired field value you just type the string,
i.e "dogs", in the criteria box in query design view, but what if I want to
omit just that field? I tried typing NOT "dogs" and got error for type
mismatch. Any help?
 
try <>"dogs"
And ensure that the datatype of your field or column is text or string.
Or you can do a conversion using Cstr(column_name).
 
Back
Top