I have a SQL query that I run against either Access, dBase or Excel. In that query I check for null fields and also, depending on user preferences, non numeric values in fields that should only contain numerics. The correct records are returned but fields with non-numeric entries have a null value returned instead of the actual contents. Is this normal or have I just messed up (which is very likely)? Here is a sample query:
SELECT * FROM [TableName] WHERE [Field1] IS NULL OR IsNumeric([Field2]) = False
Our community of experts have been thoroughly vetted for their expertise and industry experience.