Hi. I am really new to Access, and I need some help. I am trying to figure out how to add the first four letters of a last name column to the autonumber setting for my ID column. I know a lot of people don't suggest doing this in case the last name changes, or there are multiple people with the same last name, but that is part of why the business I am working for is looking to do this. We are a financial management firm, and some of our clients have multiple different accounts with us, using the same name. We need to differentiate between the different accounts, while still referencing who's account it is. I know it is done in the format portion of the autonumber information, but then people mention myID, and concantenation and I get a bit lost. Can someone walk me through how to add the first four of the last name to the autonumber account ID column? For example, WALL-128 or HALL-40. Thank you.