I'm doing some work on MS Access and I could use some help with it. I'm facing this little problem and I've attached two images to explain it.

In the Report, as you can see, I have 2 fields: "abcd" and "wxyz". And I want to add a text box at the bottom of column "wxyz" to calculate the sum of values in the "wxyz" field. In Preview, the function is working all right, but the box is appearing after the first value instead of being at the bottom.

So I've tried to move the text box to the Page Footer, but the result was an error, and besides, it's way too low.

I also tried to mess with the "Sorting and Grouping". This worked fine, but the order of the values, which is supposed to be descending, was screwed up.

I guess anyone with some experience with Access can easily fix it, but both my teacher ( !) and I are clueless.