Sort report by using a count of a field

[skyline16]

I need to sort my work order report by listing the building with the most number of work orders first.
The report is sorted by date next.
I made a query to count the number of work orders for each building. Then I told the report to sort by this 'count' and then by date.
This works until two buildings have the same number of work orders. Then the buildings get sorted by date and don't stay grouped together.
Any ideas on how to work around this?

 

[lameid]

In the design view of the report towards the upper left where the two rulers meet there is a little black box.

If you right click it you can open soting and grouping information for the report (report properties is also on the same menu).

Once you have your sorting and grouping open, add your count field first and then your date field here. You can also take them out of the query. Unfortunately reports do not always take the query sort.