Hello, I have created a very simple/basic query and would like to exclude project numbers that begin with a "3."
Some project numbers begin with a 7, some begin with a "1," and some begin with a "3." The project numbers are also different lengths.
Examples/samples of the project numbers:
10175884 (8 integers long)
7651679 (7 integers long)
31724779 (8 integers long) NEED TO EXCLUDE THESE
I am working in Design View and would like to simply add a "not" statement to exclude the project numbers that begin with a "3."
Thank you