Excluding certain items

C

ChuckW

Hi,

We have product numbers that are about 12-13 digits long. I An example would
be A45643-10243. There are a small handful that have an R in the seventh
character (i.e. A51243R-10234). I want to exclude all products that have an
R in the seventh from the left spot. How do I do this?

Thanks,
 
R

raskew via AccessMonster.com

Hi Chuck

Provided an R will always appear in the 7th position, if at all, add a
calculated field, e.g.
mid([yourfield], 7, 1)
and in the criteria cell: <>"R"

HTH - Bob
 
J

John W. Vinson

Hi,

We have product numbers that are about 12-13 digits long. I An example would
be A45643-10243. There are a small handful that have an R in the seventh
character (i.e. A51243R-10234). I want to exclude all products that have an
R in the seventh from the left spot. How do I do this?

Thanks,
Click to expand...

A criterion of

NOT LIKE "??????R*"

will do it...
 
Top