title: Microsoft Access, autonumber with year prefix
body: <p>I want to create a table with a primary key.  That primary key should include the last two digits of the year and should be followed by a one-up (i.e., auto-incremented) number for that year.</p>
  
  <p>For example, in 2014 I have 10 purchase orders, so the rows should reflect:
  141, 142, ... 1410.
  In year 2015, so far, I've had 67 purchase orders, so they should reflect:
  151, 152, ... 1567.</p>
  
  <p>How would I make the primary key include both the year and incremental number of that year?  It's important that each year returns to the incremental number of 1 and not where the previous year left off.  I wouldn't want 2015 to start off with 1511.</p>