Numbers only Query

[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?

 

[Tinius Olsen]

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?

A criterion of

LIKE "*[0123456789]*"

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


.

 

[John Vinson]

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

Ah! Ok, that's actually simpler.

Put a calculated field in the Query:

InN: IsNumeric([ID])

and use a criterion of True.