Hi -

I need to build a chart that shows the cumulative total number of folks on our email list. I gather the best way to do this is to build a summary table that shows the weekly and monthly cumulative # members, and I can create those formulas. I'm stuck, though, on how to update the summary table over time with new fields for weeks and months over time. (for example, if I put it in place today, it would show weekly and monthly results through today, but in six months I'd like the summary tabke to automatically add weeks and months as time goes by.

And do I want the summary table to contain one record per week and month, or just one record with a table that gets updated?

Any suggestions would be appreciated --