Sorting Summary Field returns

[Baylah]

Hi Everyone,

Is there a way to sort the return from a summary query? My data base has more than 9,000 orders in it, and what I would like to do is get a display for how many times a customer has placed an order.

I can use count of records which gives me a return of how many times a particular customer has placed an order and display it in the summary preview mode, but I can not figure out how to then sort the list by number of orders, so I kow which customers are placing the larges volume of orders.

Any suggestions...This owuld be very helpful to me.

Thanks,

Steve

[LaRetta]

Hi Steve,

There are probably other ways, but one way would be to create a self-join, joining the CustomerID on both sides. Create a calculation called cCountOrders (number) with:

Count(SelfJoin::OrderID)

Then create a Columnar/List report with Grouped data. Select cCountOrders and CustomerID or CustomerName. Categorize by cCountOrders and also sort by this field in descending order. You can even move the CustomerName up to the Count line and delete the body. This would give you a list of each Customer and their total order count only.

LaRetta