title: Automatically generate Date + 4-digit sequence number for ID in Access 2010+
body: <p>I need to automatically generate a 12 character value for my Business Key. Without any user interaction. </p>
  
  <pre><code>8 character -&gt; Today Date        (yyyymmdd or ddmmyyyy).
  +
  4 character -&gt; Sequential Number (0001,0002,0003).
  </code></pre>
  
  <p>The Sequential Number must reset on each new day.</p>
  
  <p>Is it possible to do this in Microsoft Access 2010+ without any coding involved?</p>