title: ORDER BY not working access
body: <p>I write a query that generates this output, but the date is not sorted using order by and when I did the same thing in the design view of access. It is doing the same thing. </p>
  
  <pre><code>SELECT 
      AIRCRAFT.tail_no, FORMAT([op_datetime],"Long Date") AS DayOfOperation, 
      COUNT(AIRCRAFT.Tail_No) AS Total
  FROM 
      AIRCRAFT 
  INNER JOIN 
      OPERATION ON AIRCRAFT.AC_ID = OPERATION.AC_ID
  WHERE 
      (((AIRCRAFT.tail_no)='xxxxxx'))
  GROUP BY 
      AIRCRAFT.tail_no, FORMAT([op_datetime],"Long Date")
  ORDER BY
      MAX([op_datetime]);
  </code></pre>
  
  <p>the output result below </p>
  
  <pre><code>tail_no                 DayOfOperation          Total
  xxxxxx              31 October 2016                 1
  xxxxxx              31 October 2015                 1
  xxxxxx              31 May 2016                     2
  xxxxxx              31 March 2016                   1
  xxxxxx              31 March 2015                   2
  xxxxxx              31 July 2017                    1
  xxxxxx              31 July 2015                    2
  xxxxxx              31 January 2016                 1
  xxxxxx              31 December 2016                1
  </code></pre>