Sums in the footers

[DaveMac]

Sorry but I am drawing a blank and need to Sum each of several codes in a footer.
There are several codes say code 404,288, 455, 955. I need to sum all the Amount fields in the footer for code 404 and so on. So in the footer you have Total Amount for code 404 – 192.77, Total Amount for code 288 – 335.88 and so on. Sorry I have been behind this box too long!!!!!
And am missing it.

 

[lhite]

Set your report to GROUP BY the code field, then put a text box with =SUM(amountfield) in the code's GROUP FOOTER.

-Larry

 

[PaulBricker]

lhite is correct about summing in the group footers but if you want all your values in the Report Footer for some reason, you can use this method. In the control source for each code textbox you want summed you can put

="Total amount for code 404 " & Sum(IIf(

="404", [Code],0))

or 

="Total amount for code 288 " & Sum(IIf([Code]="288",[Code],0))

This assumes that Code is a text datatype.  If it's not text then you would get rid of the " quote marks around the number.  "404" becomes 404.

Paul