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?
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…