It worked. Thanks very much for your help. Now I can get on with the next
stage.

Duane Hookom wrote:
I assume there are no subreports in this report. You should be able to add a
text box to the Order group footer with a control source like:
=[Order Qty]-Sum([Qty Supp'd])

I'm sorry. After previewing the thread layout my report text was clipped
and
[quoted text clipped - 22 lines]
I have tryed lots of ways to get a Total Qty O/S but to no avail. Any
suggestions would be gratefully received.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201005/1