Query text input

[pwbrown]

Hello, need some help on the best way to go about validating a text field.
Basically I have a main table which contains records imported from an excel file.
Ideally the field should be a numeric data type but because a user could enter text in excel by accident, I would get an error when inputting into a numeric data type field.
Thus I took the decision to make the data type text and check the input.
If the input is not a number I want the record to go to a error table else go to a different table.

From my thinking I'll need to create two queries. One to check if the field is a number and one to check if it isn't a number then move to the appropriate table.
I need to know how to check the text data type to see if it's a number.

Thanks for any help,

Kind regards,

Peter

 

[plog]

http://www.techonthenet.com/excel/formulas/isnumeric.php

IsNumeric() takes a number and returns TRUE or FALSE.

 

[pwbrown]

Thanks, but how would I build that into a query?

 

[John Big Booty]

This link may give you some pointers.

 

[pwbrown]

Thanks for the help guys, that solved my problem.

Kind regards,
Peter