counting digits for a number field

  • Thread starter Thread starter aeyo
  • Start date Start date
A

aeyo

Is there a built-in function that could count number of
digits in a field? More specifically I am trying to count
number of digits for SSN and find out wether there are
employees who have less than 9 digit SSNs.

Thanks for your help in advance.
 
Is there a built-in function that could count number of
digits in a field? More specifically I am trying to count
number of digits for SSN and find out wether there are
employees who have less than 9 digit SSNs.

Thanks for your help in advance.
Click to expand...

= Len([FieldName]) will return the number of characters in the field.
Whether it should be 9 or 11 characters will depend upon whether or
not you are storing the dashes with the data, i.e. 123456789 or
123-45-6789, as opposed to just displaying the dashes because you are
using an input mask.
 
Back
Top