title: Query/Expression for Previous Month
body: <p>Used as an expression in Access 2010, the below returns, for example, <code>AUG15</code>.</p>
  
  <pre><code>Left(MonthName(Month(Date())),3) &amp; Right(Year(Date()),2)  
  </code></pre>
  
  <p>How do I modify this to return the previous month, i.e. <code>JUL15</code>?</p>