Does anyone know how to splice things off of a field in Access?
For example, I'm looking to create an identification code containing the first four letters of the person's last name, the first four letters of the person's first name, their house number, and their street. How would I isolate the first four letters of the last name field into a new field? Is this possible?
For example, I'm looking to create an identification code containing the first four letters of the person's last name, the first four letters of the person's first name, their house number, and their street. How would I isolate the first four letters of the last name field into a new field? Is this possible?
