ORDER BY clause (Item) conflicts with GROUP BY clause.

Error 3094

This error can occur when you create a select query and specify grouped fields after sorted fields that are not grouped.  For example:

          You created an SQL statement29F05E5 with the specified field out of sequence in the ORDER BY Clause (SQL)15DW835.  Move the specified field to the left of the ungrouped fields, or remove the specified field from the ORDER BY clause