I need help with creating a validation rule in a table for a number that is exactly 5 digits, and i need it to include the leading zeros.
all i found was:
=len(trim(a1))=6 (works in excel, not access)
&
Is Null Or Between 10000 And 99999 (which doesn't appear to include the leading zeros)
Please HELP!!!
all i found was:
=len(trim(a1))=6 (works in excel, not access)
&
Is Null Or Between 10000 And 99999 (which doesn't appear to include the leading zeros)
Please HELP!!!