How can I generate a report for monthly figures

[tmartin]

I have attached an example where I create a monthly report as a datasheet. I would like to turn this into a real report


but do not know how to handle a design that has a variable number of months. If I were to restrict to six months how would i generate a report.

Thanks

[June7]

Building a stable report to run perpetually based on CROSSTAB query is not easy. Review http://allenbrowne.com/ser-67.html

[ranman256]

You need a form that allows user to enter the date range of the data.
Q1 would pull all the data in that range.
Q2 would be a Crosstab of Q1.