How do i show results for only numbers?

[duran007]

I have a column field that contains number, dates and text. I want to create a query that shows only number values, how can i do this? For example:


123456789
11/20/2011
ABCDE


Thanks in advance!

 

[jackd]

use the IsNumeric (yourfield) function

 

[duran007]

THank you, what about if there are dates in that feild that i also do not want included what do i do?

Thanks!

 

[jackd]

THank you, what about if there are dates in that feild that i also do not want included what do i do?

Thanks!

Create a small test with 3 datatypes,
number, string and Date. Test each with IsNumeric.
Dates and alpha chars will return False.

See http://msdn.microsoft.com/en-us/library/6cd3f6w1(v=vs.90).aspx