No you should not be creating filed for each month. Instead, you should have a table that stores your payment records. You should have a date paid and then you can create a calculation field of Date ( Month ( datepaid ); 1; Year ( datepaid ) ). This will give you a universal date of the first day in the month that the payment was made. You can then create your subsummary grouped by this calc field.
Thank you Mr Vodka for responding. I guess I'm in over my head because now I don't know how to change the database that I've created. I used the template "contact management" and customized it to my needs. The top of the each record has the customers name, address, phone, e-mail, etc. I have three tabs on the bottom, the first lists the customers individual purchase info, the second their payment infor and the last one is to add notes (although that's not working either but one problem at a time).
How would I convert the tab with the payment fields into a table? or do I need to start over?
Thanks again and any more information would be great.
No you can create a new payment table and then use a portal in your payment tab to display the payment records. When you go to print your report, you will want to go to a layout based on your payments ( could be the report layout), find the records that you want on your report ( for example just 2009 maybe? ), sort and print the report.
If you open a new copy of contact managment template, I think they show you a portal in action on one of the tabs.