Accessing values of controls in the group footer

[greatmacoy]

Can anybody share his/her knowledge how to compute the sum of the valu
of a control placed in the GROUP FOOTER. A sum of the control will b
placed at every page and at the end of the report (PAGE FOOTER, REPOR
FOOTER).

I can not use the sum([field name]) for the report footer because on
of the controls in the group footer is not a total of the column bu
instead the value from the last record.

Whay is that so, The report is actually a summary of INVENTOR
DISCREPANCIES, Physical Counts versus Recorded count OF THE ITEMS. An
the report was grouped based on ITEMCODE so that items with multipl
PHYSICAL COUNT entries (which is not unlikely) will be groupe
together. Now if they are grouped together, the Database Count o
Recorded Count for an item with multiple Physical COunt Entries will b
the same in every row because that's what in the database is. At th
end of each group, therefore, the DATABASE/RECORDED COUNT must not b
added-up, the value must also be the DATABASE COUNT for that item.
What must be added-up are the PHYSICAL COUNT ENTRIES so that when th
discrepancy is computed it will be = (sum of physical coun
entries)-(recorded count).

PLEASE HELP ME