Making a calculation in report footer of every record

[Fred's]

Hi All,

I'm trying to to make a total in my report footer. I'm explaining;

In Page Header: (I have the following labels)
ID Hour Door TransportOrContainer Footwear ALDO Feet-First Transit
Globo
Handbags Aldop NonALDOp Accessories ALDOQ NonAldoQ

In TransportOContainer Header: (I have the following text box which
make my
the records group by TransportOrContainer)
TransportOrContainer Header

In the Detail section: (I have the following text boxes)
ID Hour Door TransportOrContainer Footwear ALDO Feet-First Transit
Globo
Handbags Aldop NonALDOp Accessories ALDOQ NonAldoQ

And in the following text boxes, which are in the detail section, I
have the
following formulas

In the Footwear Text box, the formula is: =Sum([Footwear])+([ALDO])+
([Feet-
First])+([Transit])+([Globo])
In the Handbags Text box, the formula is: =Sum([Handbags])+([ALDOP])+(
[NonALDOP])
In the Accessories Text box, the formula is: =Sum([Accessories])+
([ALDOQ])+(
[NonALDOQ])

Now for each of these text boxes (Footwear, Handbag and Accessories)
which
has the above formulas, I want to create a grand total in the Report
footer.
How can I do that?

Thanking you all in advance for your help!

 

[Kevin B]

If your formula is working, just copy it to the Report Footer band. The band
determines how the sum is processed.