trouble with running sum

[b9791]

I have a report for displaying materials that have beens shipped. It displays:

tblRequests.RequestID
tblRequests.DateRequested
tblRequests.NeededBy
tblRequests.Company
tblRequests.Name
tblRequests.Address1
tblRequests.SecondaryUnitName
tblRequests.Address2
tblZipCodes_N.City
tblZipCodes_N.State
tblRequests.ZipCode
tblRequests.Phone
tblRequests.MaterialName
tblRequests.QtyRequested
tblRequests.OrderShipped
tblRequests.DateShipped

The report is grouped by MaterialID and I am trying to display the running sum for each group. But when I put in an unbound text box, set the control source equal to QtyRequested, and set the RunningSum property equal to OverGroup, the report just returns the first value in each group. If I set the RunningSum property to Overall, I get the same results. What have I done wrong and how do I fix it?

I am using Access 2002, but the db is running in Access 2000 mode.

Brian

 

[Rich]

Where have you put the text box?

 

[b9791]

I have put it in the RequestID group footer as well as the MaterialName group footer.