Hello!

I am creating a CRM for my business. I have created a form for each customer and I want to calculate my total commissions for all of them.

In my form I have a text box for each month of the year to put the amount payable for each month. (ex: Jan: 255, Feb:0, Mar 255, Apr:0, May:0.....) The label is Jan (month) and the field value is the amount. This tells me what month I will be paid in and how much I have coming for that month. Then I have a Total field that adds up the total amount of commission for that customer.(that part works fine).

What I would like to do is have a module or article that displays how much I have coming for each month for all of my customers. I would like to be able to total the amounts for the entire year if possible. I guess I would need to query all the records for each specific field. I have looked at multiple options but I keep coming up empty. I could really use some guidance!

Thanks!