What is the best way to filter out several data types in a field?

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

Guest

I want to eliminate serval types of data. For instance I do not want to show,
D,S,V, DV, M, 1, X. I keep getting an error that the string is too long.
 
Donna:

In your query enter this criteria below the field containing the data in
your example -

Not In("D", "S", "V", "DV", "M", "1","X")

Seth
 
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

How do I eliminate data in my query? 2
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Need Memo data type to remain Memo 0
data access page search code 1
Specific filter for the data in a field 1
Access SQL Query: Data Type Mismatch on TimeValue condition 3
Finding a value in several different columns 7
Excel Excel: Sort a column with #.#.# number and keep other column 0

Back
Top