I can't discern you table structure or data from the posting. I'm not sure
what you tried or what you want to display in the report.

--
Duane Hookom
MS Access MVP


"Georgethefence" u60128@uwe wrote in message news:a824d80edbd64@uwe...
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.