[RESOLVED] Grouping and sorting results

[easymoney]

I am using Data Designer with the following SQL query with MS Access 2002:

SELECT DISTINCTROW Format$([Transactions].[Cycle],'mmm/yyyy') AS [Cycle By Month], Transactions.Order, Transactions.Transaction, Sum(Transactions.Amount) AS [Sum Of Amount], Count(*) AS [Count Of Transactions]
FROM Transactions
GROUP BY Format$([Transactions].[Cycle],'mmm/yyyy'), Transactions.Order, Transactions.Transaction, Year([Transactions].[Cycle])*12+DatePart('m',[Transactions].[Cycle])-1
HAVING (((Format$([Transactions].[Cycle],'mmm/yyyy'))="Sep/2006"));

The data report is populated with data but I am trying to add sort to the [Sum of Amount].

GROUP BY Transactions.[Order]

but add a second level SORT Transactions.[Sum of Amounts] from greatest to least.

Any ideas how I can force data designer in vb6 or the sql query to return the results in the proper order?