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 as 2222]
3) what they’re relationship is within that group, [this will be two digit number starting at 01, 02, 03, etc. ß text field so it doesn’t drop the leading 0], and
4) a random number (so we can distinguish individuals who have identical info for all of the above fields) [single or double digit number]
All of this information is available in separate fields already established in the database. However, I would like to create ONE field that combines them all together as one string. For example, their new identifier that encompasses all of this information will read: “RRR-2222-01-1” (with or without the dashes)
Is there a way I can do this? I am working in Access 2003 and am fairly new to the database world.