calculation field help needed!

[GreenPilgrim]

We have a daily report that has a summary field that adds together all the pmts we take in a day. We added a new text field next to each individual pmt that states what method was used to make the pmt (cash, check, credit card, money order). My boss wants me to add summary fields at the bottom of the report, that summarizes the total amount paid by each individual method. Please help. I am stumped.

[comment]

Answered here:

http://www.fmforums.com/forum/showtopic.php?tid/196613/

Please do not double-post.