Criteria Question

[Florida Analyst]

*Access Beginner*

If I contain a set of numbers that are five digits in a column,
I.E. 02996, 03978, V3000, 02979
And I want to exlude every value that starts with 029 (by first 3 digits
only, last two are not important) how will that be be expressed in the
criteria field.

Thank you,
FA

 

[John W. Vinson]

*Access Beginner*

If I contain a set of numbers that are five digits in a column,
I.E. 02996, 03978, V3000, 02979
And I want to exlude every value that starts with 029 (by first 3 digits
only, last two are not important) how will that be be expressed in the
criteria field.

Thank you,
FA

Use a query criterion of

NOT LIKE "029*"

or, to prompt the user instead of hardcoding,

NOT LIKE [Enter three digits to exclude:] & "*"

Note that this field must be of Text datatype, not Number.

John W. Vinson [MVP]

 

[Jerry Whittle]

Not Like "029*"