How can I get the Sum of the group values in a report

[accesser]

I have a very simple table with fields:

INDX: type of text
AMT: type of number

Sample of Data:

INDX AMT

1023 329.254
1023 2698.213
3456 10025.236
3456 65.365
3456 995.698
2495 768.369

When I came to show it in the report, I made the sorting and Grouping by the INDX field. I shown in the INDX header section, the INDX value. I shown in the Detail section, the entries related to this INDX. and in the INDX footer section, I want to show the Total of the values related to this INDX. So what is the formulla that I should put in the text box shown in the INDX footer???

for example:

INDX header: 1023
INDX detail: 329.254
2698.213
INDX footer: 3027.467

But what is the forumla that I should put in the textbox shown in the footer, by which I can get the value 3027 ??


Remark: I used to make this easily. however, as its more than one years since last time I deal with the MS Access coding, I forgot it.

Please help.

Thanks,

 

[MStef]

Look at "DemoSumGroupA2002.mdb" (attachment, zip).
Look at Report1.

 

[accesser]

Thanks alot for this help and the attached file