Can anyone help me please. I'm totally new to Access 2007 but have started to
design a database for my husbands shed business.
I have an Orders Table and a Supply Table. There may be several supply
instances to complete one order.
The report which I'm having problems with is Orders Part Supplied. I've
summarised the important fields below. The report is grouped on Order No.

Order No Qty Date Supp'd
Qty Supp'd Total Qty O/S

10145 12
15/05/10
2
16/05/10
2

------------------ ----------------------

4

I have tryed lots of ways to get a Total Qty O/S but to no avail. Any
suggestions would be gratefully received.