title: Extract FileName from a given path
body: <p>I am working on MS Access and trying to extract just the filenames from a complete file path.
  Example, consider the column names in the table: </p>
  
  <pre><code>Path               | Directory   |  FileName  | extension
  ---------------------------------------------------------
  C:\temp\xyz.txt    | C:\temp     |  xyz       |   txt
  C:\myPath\tp.doc   | C:\myPath   |  tp        |   doc
  </code></pre>
  
  <p>In the Access query design view, I am using the following for generating the the "Directory" values:</p>
  
  <pre><code> Left([Path],(InStrRev([Path],"\")))
  </code></pre>
  
  <p>I am not able to extract the correct values for the FileName and extension columns. Any ideas that could do the exact without having to write it in a module would be great.</p>