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
 
Back
Top