SELECT DISTINCT already sorts the records by the fields that you specify. You could store the SELECT DISTINCT query and create a new query based on it that sorts by the desired expression. Or use a Totals query instead:

[quote name='HansV' post='770819' date='16-Apr-2009 16:33']SELECT DISTINCT already sorts the records by the fields that you specify. You could store the SELECT DISTINCT query and create a new query based on it that sorts by the desired expression. Or use a Totals query instead: