Terry Lawson
Registered User.
- Local time
- Today, 08:34
- Joined
- Mar 1, 2010
- Messages
- 12
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
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