I have to update a field in a table with some values from an excel file. Before I update the field in Access, I want to check if there are any letters stored in this field that I just imported from excel in a separate table. If there is logic, where do I run the code in what event property so it will check all the records at once?
Thanks

You could use a query if you wanted to check all the records at once but what do you want to do if a record has an error?

You could use a query if you wanted to check all the records at once but what do you want to do if a record has an error?

What is the select statement in a query to check if there is a letter stored in this field? I want to see all records if there is a letter.
E.G Field1=1234
Field1 =12L4
I want the query to display record 2 12L4
Thanks

Select * from yourtable
Where IsNumeric(yourfield) = false;

Select * from yourtable
Where IsNumeric(yourfield) = false;
Thanks a lot. It worked!