Query question on mixed data (alpha & numeric)

[montyb]

How would I go about setting criteria on a query if I want to seperate either text or numbers? I have a couple of fields that need to be stricktly numeric, but have text in them (and possible numbers as well). How do I set the criteria to show (or delete) only text and/or numbers?

thanks in advance.. [sig][/sig]

 

[tvpcman]

Monty,
If the fields are in a table, you could just change the data type to number and when you try to open the table in datasheet view, Access will delete the non-numeric fields. You may be left with blank records, but all you would have to do then is remove the blank rows and you're in business.
[sig][/sig]