I have a report that I want the total of the royality field to show up at the end of the report and I have searched and searched, but I cannot come up with the answer that I am looking for. Can some one please point me in the correct direction.


Thanks,

Michael

In the report footer add a textbox. In the textbox type =sum([royality]). That should work as long as the royality field is a numeric value.

GumbyD

Thanks for the enlightenment. I had seen that on here and tried it and tried it, but if I would have paid more attention to what I was doing I would have realized that I was putting it in the page footer and not the report footer. It makes a difference. In the page footer you get #error and in the report footer you get the answer you were looking for.

Thanks again,

Michael