title: Find value located in the last record using VBA
body: <p>I know this has probably been asked thousands of times before, but I seem to be having trouble finding an existing question that addresses this question in a wy I can understand.</p>
  
  <p>My question in how can I access a value located in the last record of a table? For example, if this is my table:</p>
  
  <pre><code>personID personName personNumber
  1        Sally      PR32
  2        Emily      PR33
  3        Joseph     PR34
  </code></pre>
  
  <p>I want to access the value "PR34" (and then be able to manipulate it if possible). I know how to find the last record with Dmax, but I'm struggling to figure out how to find a value within it. I'm ultimately trying to take the value, parse the string down to just the numbers, and increment it by one (and then append the letters back on). </p>