CInt error 1

[cochise]

I an table I have field [DiscType] as text (this can't change). Some of the values are numbers some are actually text. I need to convert the numbers to integers. In a query I'm using CInt to convert these values to integers, however, the ones that aren't numbers are returning an error, #error#. How can I weed out these errors so that only the success CInt converts are displayed. I tried using >0 as criteria, which doesn't work. Any help would be greatly appreciated.

 

[Norris68]

SELECT IIF(IsNumeric([DiscType]),CInt([DiskType]),"Not A Number&quot ...

or

... WHERE IsNumeric([DiscType])