How to sum-up the value of a control in the group footer.

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Accessing values of controls in the group footer 0
Count or sum unique records in a report's group footer in Access 2 2
SUM of COUNT? 8
Report grouped totals not resetting. 2
Accessing the value of a control in the group footer for computation 1
trying to sum a group of records but "sum" missing from Group, Sort, and Total dropdown/wizard 8
Multi-level record counts 3
Summing in a group footer 5

Top