title: ms access - generate custom id field
body: <p>I would like to create an alphanumeric id field which takes for example the first two letters of the name of a project and then starts from 10000...</p>
  
  <p>So in practice if I enter a name in a form called "institute" the id field should look like 
  "IN10001" and should increment when i select another name starting with"in.." ->"IN10002 (it should look for the highest value under "IN"</p>
  
  <p>This should be possible for all combination of two letters AA , AB, .... ZA... ZZ</p>
  
  <p>I hope you have understood my question.
  I did some research on this but couldn't find something concrete.</p>
  
  <p>Thanks in advance.
  Best Regards,
  PK</p>