Need to pull last 4 digits from an entered field and store this info in the form and in the table
New employees are entered into our Access database through an Employee Form. The last 4-digits of their SSN is used as their Payroll number. I would like to have the 4 digits automatically stored in the Employee table and displayed on the Employee form to avoid an individual mis-keying this information.
I have limited Access knowledge so an easy to implement solution would be welcome.
A very quick response would be appreciated since we need this field for a Payroll conversion we are performing.