I want to create an ID code from the first 3 letters of a surname in the surname filed and combine it with a 3 digit number to create a unique ID code. Appreciate it if anyone could tell me how this is done in Access.
Answer Question | April 4, 2009 7:42 PM
Access Database, Microsoft Access, Microsoft Access Unique ID
I have been working on a database for my research job.For our research purposes we are trying to create a unique identifier that tells us 4 things: 1) what study they are a part of, [this will be “QQQ” for EVERYONE] 2) what group they are in, [this will be a four digit number, such [...]
Answer Question | March 5, 2009 6:53 PM
Microsoft Access, Microsoft Access Unique ID