Is there a way to check the number of characters inputted into a field in access by using a query.
For example I have a field that should have a five digit filed inputted. The field may have leading zeroes.
I am trying to determine those fields which have only four digits inputted which is an error.
04589 is OK
4589 is not
How can I check for this?