Criteria Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Florida Analyst - 25 Jun 2007 19:35 GMT

*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

Reply to this Message

John W. Vinson - 25 Jun 2007 20:10 GMT

>*Access Beginner*
>
[quoted text clipped - 6 lines]
>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]

Reply to this Message

Jerry Whittle - 25 Jun 2007 20:15 GMT

Not Like "029*"

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> *Access Beginner*
>
[quoted text clipped - 6 lines]
> Thank you,
> FA

Reply to this Message