contains criteria

[saraua]

I have a field that has numbers with 1-5 digits, but also has data that looks
like "V0000", with the zero's being any numeric digit. how can I set my
criteria to not include any cell with the V in it? I have tried <>"V00*" and
that doesn't work. ist here a "contains" criteria like in excel?

Thanks,

 

[Golfinray]

New field in your query called No V's:replace([thenameofyourfield],"v"," ")

 

[Michael Conroy]

Saraua:
You said your data has both numbers and text, which I am interpreting to
mean that the field is probably defined at text. Do the numbers appear on the
left side of the column? First things first, you can't use a mathmatical
formula <> when referencing text. For "not equals" you use the word NOT, for
"equals" just type it in, Access will put quotes around it, for "contains",
use the word LIKE. Additionally, these commands can take wildcards like ? for
one letter or * for many, so

Like "V????" will give you all five letter codes with V as the first one
"V*" will give you any length code with V as the first one
Like "*V*" will give you any length code with V anywhere in it, beginning,
middle, or end

To answer your question, Not Like "*V*" will give you all codes remaining
after those with a V in it are removed. Hope this helps.