Creating Ref numbers from two fields
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

Combining fields to create a unique ID in Microsoft Access
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