sum of total fields....

[Himitsu]

I have a question. I have been trying to see the total of all fields for the found record sets. What I have is like an ivoice DB. so each record contains one customer and all the items he/she has bought. Then I have an ivoice total for each record. Now when I view all of them in a list, I can see each customer name, invoice total and when they paid. What I want to do is make a field in the header that will display all the money collected for that list. I made a field that contains the sum of the field "invoice total" and put it on the list. But nothing. I know I am missing stuff but I just can't figure it out.

[Fitch]

Use a Summary Field that's the Total of Invoice Total.

If necessary, instead of a header, try a Leading Grand Summary Part.

[Himitsu]

Thanks Fitch... it just shows how little I know about this stuff... thanks