Report totals

[karen scheu via AccessMonster.com]

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

 

[Guest]

Either try using the report wizard which allows grouping, summary, and sum
totals
or
In the Report design view use the "sorting and grouping" tool button.

M.Afzal