Summing/Grouping in Reports (1 Viewer)

I have a table which contains an order no., each of which may contain multiple items, these items may be in 1 or more of the orders.

For example:

Say the table contains:
Order No, Item No, Qty
12 AA 1
12 AB 10
12 BB 99
13 AA 3
13 BC 7
13 BD 22
14 AA 9
14 BB 44
14 BD 11

How can I get a footer on a report which contains the above in the report detail for:
A count of the no. of orders i.e. 3?
A count of the no different items i.e 5, AA,AB,BB,BC,BD?
A total qty for each different item i.e. subject to my maths!
AA 13
AB 10
BB 143
BC 7
BD 33

Regards

Terry Lawson

Have to do independent aggregate queries. Join those queries to the primary data query or use them in subreports.