I need to create a field in Access that included both text and the autonumber feature. We are a non-profit hospital organization and we have multiple locations so we want to create an ID field that is unique by location and still uses the auto numbering feature to generate the ID field. I think we need to create this field on the form versus on the table, and we'd make a change in the preceding letters for each location form.
While I'm certain one can accomplish this using a VB formula, but I don't know how to do this. I need the results of the field to look something like the following:
If someone could please assist in how to do this within Access...I'd me most grateful.