SUM IN REPORT FOOTER?

[Frederic]

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!

 

[Duane Hookom]

Have you tried exactly the same expressions in the report footer section?

 

[Frederic]

Yes, I've tried the same expressions in the report footer section

Have you tried exactly the same expressions in the report footer section?

Hi All,

[quoted text clipped - 27 lines]

Thanking you all in advance for your help!

 

[Duane Hookom]

I'm having a little trouble seeing your results and identifying what is wrong
with them. What values do you want summed in your report footer? Give us some
help with the fields and what you expect to see in your footer.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

Yes, I've tried the same expressions in the report footer section

Have you tried exactly the same expressions in the report footer section?

Hi All,

[quoted text clipped - 27 lines]

Thanking you all in advance for your help!