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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use In() Expression as Query criteria with guts from Function 1
Access Dcount (multiple criteria) 3
data mismatch 2
Query Criteria not filtering out correctly 5
All-Record criteria in a query...hmmm 4
Query criteria in a memo field 1
Data mismatch error 2
Access SQL Query: Data Type Mismatch on TimeValue condition 3

Back
Top