Numbers only Query

  • Thread starter Thread starter Tinius Olsen
  • Start date Start date
T

Tinius Olsen

Querying table field labeled ID Numbers.
Records contain predominately numbers, up to six digits,
but there are occasions where an ID can be alphanumeric:
examples C6, C4-35, or X36
Made Query with following Criteria <"a*"
This seemed to remove ID's starting with letters such as
the C6 but seems to have left those ending with a letter
such as X36.
Is it possible to get the Query to list only those ID's
containing numbers regardless of where the alpha
characters are located?
 
Thanks John for the information. I probably did not state
the problem accurately - out of the following set of ID's:
3506
3507
3508
36X
57B-2
B-1
I want the query to only yield the non alphanumeric ID's
i.e.
3506
3507
3508
-----Original Message-----
Is it possible to get the Query to list only those ID's
containing numbers regardless of where the alpha
characters are located?
Click to expand...

A criterion of

LIKE "*[0123456789]*"

will return records where the field contains any numeric digit in any
position.


.
Click to expand...
 
Thanks John for the information. I probably did not state
the problem accurately - out of the following set of ID's:
3506
3507
3508
36X
57B-2
B-1
I want the query to only yield the non alphanumeric ID's
i.e.
3506
3507
3508
Click to expand...

Ah! Ok, that's actually simpler.

Put a calculated field in the Query:

InN: IsNumeric([ID])

and use a criterion of True.
 
Back
Top