Help in Access 2000 with a Query

[Schmals]

Hello Everyone,
quick question, i am trying to create a query in access when i notice that i need to filter/omit certain lines. the problem is that in this column are id codes, that do not follow a particular order (ie. 1-200). they are things like wxy342 or credit. is there an easy way for me to filter this out ( i actually have 3 items i need to do).
Thanks.

Schmals

 

[ETID]

just 3 odd items?

then in the criteria for that field...


I.E.

is not in("wxy342","credit","odd stuff&quot

 

[ETID]

Ooops...use just "not in"

unless you are looking for a null value the use "is not in"