title: Convert YYYYMMDD to mm/dd/yyyy format
body: <p>I need to join some order dates from two different queries (drawn from linked access databases). In Query 1, the date is formatted like YYYYMMDD, no slashes or hyphens. I don't think access can recognize this as a date. Query 2 has dates in the format, MM/DD/YYYY I would like to change the order dates in Query 1 to.  </p>
  
  <p>I am not sure how to start doing this.</p>
  
  <p>Any help would be greatly appreciated!</p>