I am trying to create an on time delivery report.  I have a query with
order number, ship date, due date and daydiff:[due date]-[ship date]
sorted by Division
My report needds to look like this:

Summary by Division
Division    %Late   %On Time  Avg Days Late   Avg Days On Time

How can I accomplish this?  THe query selects the detail rows (not grouped)
.  How do I do the total counts of orders within a division, the count of
orders where daydiff < 0 and a count of orders where daydiff >= 0

Thanks,
Karen