Please help on criteria slection

[Access_help_rob]

Ok i have a field called text01 which basically is a afield i have put together which says "Old stock code do not use, use 012345" Now thats the description for some stock codes but in this query im bringing in stock code and description, but i dont want to display any stock codes where the description says the above, how would i go about doing that?
please help
cheers
rob

 

[Len Boorman]

In your select query put description criteria

Not Like "*do not use*"

This should then exclude all records whose description contains do not use

Len B

 

[Access_help_rob]

thats awesome cheers man
thanks
rob

 

[Len Boorman]

Check the results carefully

Try changing the criteria to Like "*do not use*" and have a look through the records you are excluding.

Sometimes viewing the opposite of what you want highlights items you would otherwise miss

L

 

[Pat Hartman]

It is only appropriate to use "like" if you are supplying partial key values. In this case use "=" or "<>"