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])

--
Duane Hookom
MS Access MVP


"Georgethefence via AccessMonster.com" u60128@uwe wrote in message
news:a82be5f9a796a@uwe...
I'm sorry. After previewing the thread layout my report text was clipped
and
I agree even I can't understand the report from that. Sorry for the
confusion.

Fields on report a
Order No (grouped)
Order Qty
(Both fields are in Orders Table)
Date Supplied
Qty Supp'd
(Both Fields are in Supply Table)
Total Qty O/S
This is the field I'm having trouble with. There may be several Supply
entries against one order. I need to display a total which takes the Order
Qty and minuses the Total Supplied from that.
Many thanks for your help.
Duane Hookom wrote:
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.

Can anyone help me please. I'm totally new to Access 2007 but have
started
to
[quoted text clipped - 19 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